Moving Data From 3 Worksheets Into 1

It's possible but we need much more detail.

Originally Posted by jenmc84

they change every month to be 'this month plus the previous 2'.

Do you mean that the data in the files change, or the file name changes? Give us a specification for what the file names are.

It's challenging to make dynamic links to other workbooks that will work when the workbooks are closed. The way to do this is probably to open the three workbooks, copy the sheets into your master workbook.

You said that you want the data from three different sheets to be copies on a single worksheet. That means you need to show us an example of the data layout in each of the three source data sheets, plus the layout you want in the consolidated sheet.

Hi jenmc84
If these workbooks are identical layouts, you can use PowerQuery for whatever you want for any part of them.
According to your words, you can use append or merge to place each workbook in a query and then do the append for all of them in one query then do the adjustment and make it into one.
For the source of the files, you can place them in a folder and then pass this folder path to the power query as a source path.
Also, you can use parameters to add the paths, or direct links if links are not changing from one month to another.
After solving the path issue, you can append as said, and then add a custom conditional column and set your criteria to get the items for the time duration you are looking for.
A sample would help.