Don't know about mac but easy enough to do with a looping macro to
open each worbook
for each worksheet
copy the data to the destination workbook at the next available row
next worksheet
close the source file.
next workbook
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Daphtg" wrote in message
...
I have 9 workbooks each containing 7 worksheets which I need to combine
into
one data file to standardize addresses through the Post Office. I am
using a
MAc and 2004 Excel. I have no access to "ACCESS". Is there a simple way
of
doing this?

Thank you in advance for any help!!