I have a workbook with multiple worksheets with a macro that extracts data from each worksheet, the data is than pasted into the extract' worksheet in the same workbook.
A change in requirements has resulted in the sheets being moved into new workbooks with each workbook being renamed daily with the suffix of the date.
All workbooks will remain in the same folder
There is still a requirement for the data to be collected in the COMMSMAST - Copy workbook
I have attached an abridged version of the model showing how the core LOOKUP value in column A of the 'LIST COMMS' sheet will need to be changed to the format shown in column I of the sheet 'ADMINISTRATION'
The present macro works perfectly, all I need help with is how to include the instruction to OPEN each of the workbooks shown in column B of the 'ADMINISTRATION' before the existing macro is applied.