I have recently signed up to the forum and my VBA code knowledge is novice at best. So far, I have been able to search the forum to find solutions and I have to say the knowledge contained on the forum is absolutely first class and something that I hope to be able to aspire to one day...

So, the problem I am trying to solve is:

I have 35 budget workbooks saved in 9 different folders. Each workbook contains a different number of named worksheets in exactly the same format that pull through into one consolidated worksheet.

For example:

NA budget workbook: CONSOL (sheet1) 6001 (sheet2) 6002 (sheet3)
AP budget workbook: CONSOL (sheet1) 6003 (sheet2) 6004 (sheet3)

I now need to input the data from each of the worksheets into an upload file and I was hoping there was a quicker way of doing this?

Ideally, I want to create one master worksheet of data (in a separate workbook) that will look at a list of the named worksheets (eg 6001-6004) and will search the 9 folders to locate that worksheet and then pull that data through to the master worksheet?

I am really hoping someone will be able to help me but if not, thanks for taking the time to read my first post anyway!