Try this Ryan
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message oups.com...
I have A Number of different workbooks with different filenames in a
single folder. All Excel files have the same heading rows, & # of
columns. Basically I want to set up a macro that will look in a
specified folder, take all the data from all files, and put them into a
Master File. I am not very experienced at programming, but this is
something that I have to do every day and this could truly help
streamline what I am doing. I am sure this can be done, just not sure
where to start. Can anyone point me in the right direction? Thanks so
much!
Ryan