Ron,

That was exactly what I was looking for! Thank you very much!

Regards,

Ryan

Ron de Bruin wrote:
> Try this Ryan
> http://www.rondebruin.nl/copy3.htm
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> <ryan.lindner@gmail.com> wrote in message news:1145389231.798807.203170@j33g2000cwa.googlegroups.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
> >