How to Keep Trackers in Sync. If you use this exact format, you can import rows across different sheets using import range. First add four more columns to your tracker.
| I | J | K | L | |
|---|---|---|---|---|
| 1 | Import from | Tab Name | Start | End |
| 2 | https://docs | Sheet1 | A8 | H8 |
Then import data from another tracker using this formula, adjusting the cell references as needed:
=importrange(
I2,
CONCATENATE(
J2, "!", K2, ":", L2
)
)