Macro to add worksheets based on tab color

[uapak90]

Hi,

I am new to macros - have done beginner stuff but nothing to this extent. This is the type of workbook I have and I need to add values of those tabs to a different sheet (they all look the same, just with different numbers. Its kinda like a group and sub groups and the numbers from the sub groups need to be added to the larger group, then that number needs to be added to a larger group etc). Here is a little visualization:

RED TAB / BLACK / YELLOW / YELLOW / WHITE / WHITE / WHITE / YELLOW / BLACK / YELLOW / WHITE / WHITE / YELLOW / BLACK

So what I have to do is add all the contents of the white tab to the yellow tab adjacent to the left of them. Then add all the contents of the yellow tabs to the black tab adjacent to the left of it. Then add all the black tabs to the main red tab in the beginning.

I can't seem to even start on this code ... any help would be great

I was thinking maybe have some sort of input system where a user selects which worksheets should add to which worksheet - and repeats the process but it seemed kinda lengthy

 

[rguy84]

Obviously the tabs are related somehow. Wouldn't referring to the Sheet name vs color be easier? Or do the colors change regularly?

 

[uapak90]

The issue is, i would need to run this on several different workbooks and the sheet names as well as the quantity of worksheets would change for different workbooks