I want to create a summary worksheet and link cells from another workbook that contains all the data to it. I know how to link a cell from a specified worksheet to another when the cell always remain constant, eg = A1. But the cell is not constant. At the moment I have to copy and paste the information which is time consuming.

So basically, I would have two separate files, one being the summary file and the other being the file that contains all the data. However, my file that contains all the data has a new sheet added every week and filled in. The layout of each sheet is exactly the same, just new information is entered. Therefore, by the end of the year there are 52 sheets.

What I would like to be able to do is have the summary sheet update with the new information from the current week (ie the new sheet tab that has been created and filled in).
Are there any options to be able to do this? Any help would be appreciated.