Copy data from 3 separate workbooks into one master file VBA

Hello,

I am seeking help on a some VBA I wrote to copy selected range, within selected sheet for all workbooks within a file folder.

Here is what I want to do:

have the zmaster run a macro to bring in all date from the sheets labeled "Reach". I want columns A-V and then all the way down to the last row of data for each. The amount of data will change very month, so that is why I need to to the last row of data. Then paste all those results from the 3 active workbooks (FS Measures Jan 23, FS Measures Feb 23, FS Measures Mar 23) in the Master starting at A1 on "Sheet1". Here is the code I have so far. However, I get a return error 1004. I would like to be able to rename the workbooks being copied anything I want at any given time. I am not sure why the code is not reading the file names. Workbook is attached.

Please Login or Register  to view this content.

Rtn error.PNG

file path.PNG

Hi alansidman,

that did work! However, I want to run a SUMIF formula from one sheet to that new power query table sheet and the formula is returning zero. The calc's are turned on. Do you know why my formula wont pick up any of the data in the table from power query?

Thanks alansidman, that worked!