I have a google spreadsheet with a master sheet that has a list of rows (first column is a key and other are some data). I want to be able to have more sheets in the doc that would have the same list of keys but just different kind of data associated with each key. I tried importrange and it does almost what I want except if I add a new key in the middle of the list in the master spreadsheet, the data on the other spreadsheets doesn't move down with their corresponding keys (only the list of keys shifts down). How can I tie the data to the keys in the other spreadsheet? 
Google spreadsheets keep keys in sync between sheets
google spreadsheets