VBA- updates all sheets into one master sheet

[99Ahmad99]

I have one excel workbook, containing (30) sheets. all sheets with the same setup, same arrangements, same headers and same titles.
I need a micro, once there are any updates, in any of those (30) sheets, I need to copy those updates and put them in the master sheet which is within the same workbook.
Thanks.

 

[My Aswer Is This]

I would think that would be difficult. So you want the sheet named "Master" to look exactly like the other 30 sheets correct?

So if I delete row 23 from sheet 14 I need to delete row 23 from the master sheet correct?

if I delete row 20 from sheet 17 I need to delete row 20 from the master sheet correct?

 

[EnG_TeLeCoMm]

I would think that would be difficult. So you want the sheet named "Master" to look exactly like the other 30 sheets correct?

So if I delete row 23 from sheet 14 I need to delete row 23 from the master sheet correct?

if I delete row 20 from sheet 17 I need to delete row 20 from the master sheet correct?

exactly, if there is any addition, deletion should be reflected in the master sheet. Not only in respect to rows but also the values change

 

[My Aswer Is This]

So if on sheet 12 "Alpha" is entered in Range A1 you want "Alpha" entered in Range("A1") of sheet named "Master"
Now what happens if on sheet 23 the word "Bravo" is entered in Range("A1")
I guess now sheet named "Master" will have "Bravo" in Range ("A1") is that correct"

And how many sheets are we talking about here. Are there 5 or 20 sheets in this workbook?

 

[My Aswer Is This]

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

 

[SpillerBD]

I think you're doing it backwards. IMHO, you should keep all your data in ONE table and report on it in different views. You keep your family in the same house rather than a house for your wife* and each child.
However, yes, you can use VBA to combine sheets as you describe, but Power Query would be better. Using PowerQuery, you can make a reference to Original Sheet Sheet and Row as part of the Query Process.

 

[alansidman]

Quickly accomplished using Power Query

 

[99Ahmad99]

appreciate your all reply.
@

@alansidman: the problem with the video, it will not maintain the format of the sheet, there are headers, logos and others that will be removed because using the way the video need to have a table format only, I have some areas for equations and small counter and indicative dashboard. please use this URL to download the sheet, maybe it will express better than I do in terms of what I meant to say or describe.​

IC-Schedule-of-Shop-Drawings-Submittals Without DashBoard-Logo-ready-25.12.2021.xlsx

 

[alansidman]

The part about table format only is correct. This is about rearranging data and not about keeping pretty spreadsheets. Any window dressing or eye candy should be added in Native Excel after you have manipulated the data. You have posted to a third party site I am not familiar with. I will not be downloading from sites that are unknown to me. Good Luck. I am passing on any further help to this thread.

 

[99Ahmad99]

Thanks for the reply.
what about this idea, what about keeping those 30 sheets as they are, and the update will be on a master sheet?
this master sheet will always be empty, and once I run the micro, each sheet will copy its contents to the master one? every time I run the mico, the master sheet will erase its previous contents and copy from those 30 sheets so it will be always updated? how is that sound?