I've reviewed your pages and have been unable to find what you have
referenced below. It may be items that are not collectively stated in one
category so I'm missing it. Could you please point me in the right direction?

However, looking at what I think you have suggested below, I think it is
important to mention that the worksheet titles may not necessarily always be
named the same thing.

If there is a way to pull specific cells from all of the other worksheets in
the workbook, or all the worksheets to right of the active worksheet, or
something similar... and then order them by one of the cells pulled, I would
be a happy duck. :) Even if they weren't ordered by the cells pulled, I
think I could be a happy duck, but that is preferred.

Thanks for your assistance!

Please let me know of any suggestions.

"exceluserforeman" wrote:

Hi,
I think a userform would be best suited.

A Combobox or listbox filled with the workbook names
A button to do the actions
an update button that checks for more files

See my stuff at:
http://www.geocities.com/excelmarksway

You can send me the info if you want me to write it up.

- -mark