copy data from multiple tabs to one master tab

[dylan.raymond]

Good afternoon,

I have a project ive been working on, most of which ive figured out. its the last bit im having trouble with.

the project is a roll call tracker, tab 1 is a summary showing the total numbers for the status of the people. (solved)

tabs 2-5 are the roll call sheets for the different departments, formats are the same only the names are different. (solved)

tab 6 is a master list showing all names and status, basically just copied the layout of the previous tabs just all of them together.
the problem im running into is having the master list communicate with individual tabs.

I want it so that when i switch the status of someone on departmental tab it updates on the master list and have the master list sort-able. im currently using a drop down menu to select the status of individual persons, then using a simple for loop to check that status and change the background color of that row based on the status. (the for loop is figured out)

any help would be greatly appreciated.

[Vraag en antwoord]

See the yellow banner at top of this page how to attach your file.