How do I have multiple workbooks open and have a menu to switch between them?
I need to have approximatly 5 workbooks to use due to the size of the
workbooks would negate using just one for all of the sheets.

Any help would be greatly appreciated.

If you are wondering what I am referancing you could go to traderxl.com and
watch the analyzerxl demo and see the tabs at the top of the sheet under
addin menu.