Linking Checkboxes to cells on multiple sheet

[Crusher3468]

I am working on a Project to use to track the collection a various data. In the project I have different sheets that organize the data into groups of similar data and I have a checkbox next to track what data has been collected. Now I want to create a sheet that works as a master list with all the data from all the data in a single list. The problem I am having is both lists have checkboxes for tracking data collected but I can't find a way to make is so if I check the checkbox on the master list it also checks it on the sub list in the other sheet and vise versa. Is this possible at all or am I just out of luck

[#2]

Bold question: Why are you keeping more than one list of the same information? Keeping just one list of data solves this issue entirely and makes managing of and reporting on your data ever so much easier.

[#3]

@JKPieterse 

Because the data I am tracking is a list of items collected for a game so I have separate sheets to track the items by item type but I also wanted to create a sheet that worked as a master list of all the items. Currently the seperate item lists have a check box linked to the cell it is in so I can track the information and highlight the row once the item is marked as collected. I am trying to find a way so that regardless of whether you mark the item collected in the master list or in the categorized lists it will be marked off on both list and apply the highlight. Honestly I'm not even sure this is currently possible in excel but I figured I'd ask to see if by chance it was.

[#4]

You can, but it is far easier to add a column to your master list that says which "sheet" that data originally was on. Format the range as a table and you can add a slicer to easily filter for what used to be separate tabs in your file. Much easier to maintain.