Automated copying of different values from set cells in multiple sheets into master sheet

Hi there,

I have searched through the forum for a solution more specific to my question however I am unable to modify to cater for my problem. So I'm really hoping someone could help me out (please!)

Attached is an example with the desired output in the worksheet named "MASTER".

I would like a macro that would automatically import values from each CODE# worksheet into the MASTER worksheet. The values are all contained in a table that is set in the exact same position in each worksheet. Each table is set at the same position in each worksheet, but has different values. And when input into the master worksheet, they should be underneath each other with format set out in the desired output.

Also, there is a set cell with the worksheet name in the top left corner of the worksheet. Instead of changing the worksheet name, I would just like to go through and change the name of that cell, which would then correspondingly change the name of the worksheet.

Is this all possible? Please let me know if you require any other information.

Thanks!

Hi! Maybe im not getting entirely what you want to do? As i understand you want the master to show the same info as CODE1,CODE2, and CODE3, but with a differeant formatting? If this is the case you can simply highlight for example cell B3 in the master and write =+CODE1!G5. Or if you just hit +, you can click on the cell in CODE# you want to show.

I guess the idea behind this is that ill have over 1000 worksheets, and I want a highly automated process of adding all these tables into the master table if that helps? So all the tables from the 1000+ worksheets into one.

Does this help?

Please Login or Register  to view this content.

At least for the first part, maybe.

Originally Posted by JOHN H. DAVIS

Does this help?

Please Login or Register  to view this content.

At least for the first part, maybe.

Hi John, that worked amazingly well! Thanks so much!
There's just one thing that isn't working for me, which is probably due to my lack in sufficient info (sorry!) - is that, the worksheets named CODE1, CODE2, CODE3, will also include numbers that are not consecutive of each other, e.g. CODE68, then CODE72.

Is there a way to factor that into the code?

Thanks so much thus far!

Maybe:

Please Login or Register  to view this content.

Change:

Do Until i = worksheets.count

To:

Do Until i = 15--This should be the highest value for your Sheet-Code names. If it is 72 then

Do Until i = 72