Any help is greatly appreciated.
I have about 20 workbooks with different file names for different projects all saved in the same folder. Each workbook has about 10 worksheets and each worksheet is named in a similar fashion in each of the 20 workbooks (eg. revenue, cost, variance etc.). I want to pull out a worksheet named 'forecast' from each workbook into a master workbook so that the master workbook would contain the 20 forecast worksheets. Is anyone able to help me with the code to perform this task?
Thanks in advance!