VBA Code to link spreadsheet data

[Tira]

Right!! I forgot about that. Problem solved! Thanks.

But the code only processed the "DME"s. How can I get it to process the rest of the tabs (i.e. PTJ15, etc.).

I think you mentioned about the naming conventions somewhat above but I need to know what to do to make it work.

Thank you so much!