How do I copy several files into one master

[Gonefishin]

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?

[Leith Ross]

Hello Gonefishin,

We could better answer your question if you provided a couple of sample workbooks. Say 2 of the daily workbooks and a "master' that shows how you would like the data arranged.