Ok... first I would like to say thank you to anybody who attempts an answer
for this... I really appreciate any ideas.

What I would like to do is to have a workbook with a worksheet that pulls
from specific cells on other worksheets. The kicker is that other worksheets
are added as they are turned in so they are not in there at the beginning.

I'm guessing this (if at all possible) would have to be done with code...
any ideas?

Once again, it's a very simple go to other spreadsheets (I could probably
manipulate it if it looked at all) and pull a specific cell back to the first
worksheet. Would be helpful if it also ordered them by the first cell it
pulls back in.

Again, thanks for any assistance.