I have a daily sheet saved using a date as the file name.
I have this formula to pull the data into another file.
='[DISPATCH MASTER CDL UPDATED 11.25.2020.xlsm]INPUT'!$A$3
The issue I have is the file name [DISPATCH MASTER CDL UPDATED 11.25.2020.xlsm] will change.
I need to combine the data from approximately 10 different files and then i will combine the data on another tab within the new file.
This is for a payroll spreadsheet, so will have multiple files, one for each day of a pay period, and another file to compile all the other daily information together.
I am at a loss of how to do this with out performing a lengthy copy paste from each file.
Bookmarks