How to put multiple files into one

I have an excel file for each day of the month. Each file has 2 sheets for sure and some files have 3. I want to make one master file at the end of the month that shows all sheets.

*1st sheet is master report. 2nd & 3rd sheets are created as a pivot table

Any help would be greatly appreciated.