Merging

I have the months profit on 31 different excel files. how do I join them all to appear in one file that has 31 tabs.

Hi,

type =
go to source
press enter

HTH
Carim

Originally Posted by strike

I have the months profit on 31 different excel files. how do I join them all to appear in one file that has 31 tabs.

Permanently? If you want to do it permanently, just open each book, the right click the tab, and select move or copy, then move each sheet to a common book.