Copying data based on ws name

[struf]

I need to copy data from one wb with multiple ws to another wb based on the name of the ws

First wb has 50 ws, one for each state. EX: C:\ qtr1.xlsx

In another folder, i have 50 wb , again one for each state (EX: C:\2011\ AL.xlsx), which happens to have 4 ws

I would like to copy the data on each individual in C:\ qtr1.xlsx to the appropriate wb in

C:\2011, and to make it more interesting, I need it copied to the second tab , let's call it "supplies". The Supplies tab is the same in each Wb

Now because I do not want to have to open each wb, i have found several macros that will open and close these wb once i find another macro to do all the copying. So i am not worrying about that at this time

I have tried looking at lookups, indirects, etc, but to tell you the truth, i don't even know where to start anymore.

While an answer to my problem would be fantastic, I would be very happy to get any sort of guidence so i can continue to research it.

Many thanks in advance. ANy direction is extremely appriciated.

Regards,

struf

 

[Norie]

What's the problem with the data?

Like I said the copying part of the code was pretty simple.

If you need something more involved post details - I think that's what the main point of your original question was anyway.