I'm doing due diligence on some acquisitions, and there is too much data that I have to keep track of. I'm thinking that it would work to have one master Google Sheet with multiple tabs where each tab is a different category of data.
However, I'm going to be analyzing hundreds of deals per month, and I want the rows on each tab to be synced. If "Deal A" is on Row 37 of Tab 1, then I want "Deal A" to be on Row 37 of EVERY tab.
The problem is that it's not uncommon for me to delete rows or cut/paste rows, and if I fail to manually cut/paste the same row from all tabs, it's going to wreak havoc on my data. Additionally, if I insert a new row between Row 37 & Row 38, it's a lot of manual work to go through every additional tab and manually insert rows.
SO... is it possible to have a sort of "master" where if I make a change to the master, it will change all tabs?