How many sheets in each of the 5 workbooks?

Do these sheets have unique names that would not be duplicated in each of
the 5 workbooks?

Maybe just move the sheets from each workbook into one new workbook.

You can do that manually. Select all sheets in a workbook at once and
right-click on active sheet tab and Move or CopyCreate a copy

Otherwise you get into VBA which Ron de Bruin covers very well at his site.

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

Scroll down to Copy/Paste/Merge Examples


Gord Dibben MS Excel MVP

On Wed, 19 Aug 2009 14:23:01 -0700, Ken C wrote:

I'm not a programmer so this may sound dumb, but how do I create one workbook
combining about 5 workbooks or better yet take 5 workbooks and put them all
into one master workbook where they cam be tabed through. I'm not versed on
vb so I don't understand it very much. Any help would be greatly appreciated.

Ken C.