Create single worksheet from multiple workbooks with 4 worksheets in each workbook

Dear Experts, I am looking for some help/ideas on how to create one worksheet from multiple worksheets and workbooks. Purpose of this exercise is to get all data in one place and then create a pivot table.
All workbooks are in same format and each workbook is 4 worksheets
Worksheet 1 is Year to date actual data
Worksheet 2 is Year to date Budget data
Worksheet 3 is Month Actual
Worksheet 4 is Month Budget
Total number of workbooks 24
I look forward for some guidance on how to go about it using VBA (Data is sensitive and I cant post it).
Please note my access comfort level is fine and if all this can be exported to access table then I can make a pivot table using access table.
Best Regards/VKS

http://www.rondebruin.nl/tips.htm