how do i put a number of excel files into one big one?

[Ianwal]

i have a number of one line excel sheets that i want to put into one big one.
Is there a better way than cutting and pasting

 

[Peo Sjoblom]

You need to use macros unless this is a one timer and the number of files
are not that many

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

look under the Copy/Paste?Merge header