I posted a question under the Heading "Dynamic Sheet Copy" and wanted to
integrate
2 ideas to create a macro that would ask what sheet you wanted to look for
and then copy all of these sheets into 1 master file (the one in which the
macro is in?)

I tried to integrate the replies I got into Ron's original Macro to no avail.

I was hoping Tom or one of the other wizzes out their could take a look at
my problem to see if it is indeed possible (im sure it is, with more
knowledge than I have)

This macro would seem to have a wide variety of uses for many people.

Thanks in advance

John