Go Buffalo! LOL Is that Buffalo NY?
IMHO, I think you should have one master sheet of data covering all cities and dates. Splitting the data among sheets by month is probably going to create more issues than not and likely unnecessary.
Then I think you can just use a pivot table to extract your data. See attached if this works for you. You can filter by jurisdiction on top or run it for all jurisdictions. I changed the months from your tabs to Jan, Feb, and Mar merely for illustrative purposes. If you want you can enter specific dates (e.g. m/d/yy) on the Data tab too and set up the Pivot to group by months, quarters, years, etc.
Anyhoo...that's my suggestion. Let me know if this looks like it might work.
|