Creating 12 monthly reports from a single file

[GRCDickinson]

I am trying to create 12 monthly reports (January through December) that are propagated from a single source EXCEL sheet that contains all the data for the year. Each report should update when data is entered on the main sheet. How do I do this?

[#2 · Accepted solution]

@GRCDickinson 

I think you may try "Power Query" for the files. 

[#3]

Thank you for the help. I was able to build the spread sheet as desired. Have a Great day!

Michael

@Man Fai Chan