Each month I have a number of Excel files populated (each having 1 worksheet
which is labeled, columns/ rows are formatted, so they have blanks in them).
I need to be able to combine them, so that each file becomes a worksheet
within a master file. Any way to do it without moving/ creating a copy each
and every time? Thank you.

Hi Margo

Start here
http://www.rondebruin.nl/fso.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Margo" wrote in message ...
Each month I have a number of Excel files populated (each having 1 worksheet
which is labeled, columns/ rows are formatted, so they have blanks in them).
I need to be able to combine them, so that each file becomes a worksheet
within a master file. Any way to do it without moving/ creating a copy each
and every time? Thank you.