I need to synchronize 2 separate spreadsheets.  Things that do not work -=importrange (Since I want two way sync and this only offers one way)Filter views, filter data, (Since I want to do this multiple times in one MASTER sheet, connected to sub-sheets that need to be private from one another)I've seen the same scripts posted multiple times when this question is brought up but they do not work. Or maybe I am just doing something wrongExample -   I have 5 Spreadsheets(separate files), and 1(MASTER) Spreadsheet with 5 worksheets.I want to sync each of the 5 separate files to the 5 worksheets in the master and be able to dynamically edit them.Am I just wasting my time trying to do this with Google Sheets? And if so, what should work? 
Bi-Directional (two way) Sync for Separate Google Spreadsheet files
google spreadsheets;synchronization