I have an excel file for each day of the month. I want to make one master with a sheet for each day. The problem I have is I have been trying to copy & pate but for some reason all sheets have the same info after pasting . For example I have an average & it shows the same average for each day which I know is not true.

I do use a template when I do these daily reports which I think is the reason why I am getting same info on all the sheets.

Is there a way to import all files do different sheets?