Combining Project Tracking Workbooks

[Ralvarez]

Hello all,

I am new to this forum and fairly new to excel programming. I currently use excel to do project management tracking. For every project i create a new excel workbook based on a template i have made. These workbooks have anywhere from 10 sheets to 25 sheets and in a year i track from 20-50 workbooks. Is there any way to compile these workbooks into one file and still keep the workbooks separate from each other (possible through workbook tabs or a built in file directory for all the workbooks)?

I have seen many posts on merging these workbooks but i have not found one that does what i am after (And yes i am fully prepared to admit that sometimes i may not get what i want!)

[Ralvarez]

Additionally, would Access be capable of this "multiple workbook" concept? I am not as familiar with access but i will jump in feet first if it can.