Auto-populate worksheets from a source worksheet based on data input

MattChisholm ,

You have many options. I recommend PowerQuery (PQ). Setup is a bit tedious but straight forward. One setup and we add new transactions to Rec Excise Tracking we can click the Data > Refresh All and every tab will update nicely. 

NOTES

1. PQ will convert Rec Excise Tracking to a table so I recommend making it a table and naming it tblSource before PQ does so the name means something. 
   
   
2. Use PQ to create each result query. You will need 1 for each tab. Just duplicate the one I created, rename it, then double click the Filtered Rows step and choose which provinces to include for each query.
3. Load the query to the appropriate tab then insert a few columns:
   1. Row - enter formula =ROW()-ROW([#Headers])
   2. Start - enter formula =IF([@Row]=1,B1,INDEX([End],[@Row]-1))
   3. End - enter formaul=[@Start]+[@[Add/Sub]]