Hi Bill,
Look into Ron web he has a macro to do what you need
http://www.rondebruin.nl/copy3.htm
http://www.rondebruin.nl/copy2.htm


"Kentucky Bill" wrote:

I have feedback from 26 people in different files with the exact same format
and columns names, etc.

Is there a way for me to merge these all into one file without opening,
copying and pasting into a master file?