expand and collapse across multiple sheets with one control

Hi,

I have a workbook with ~15 sheets (and growing) in it, all of a varying number or rows. In column A I could always put an IF statement that if there is data in a particular cell, return "filled" and then manually filter to only show the "filled" rows, however I was wondering if there is a way to have one "toggle" (if that is the correct word) on one master sheet that would collapse all those empty rows? I have attached a simplistic example where I would like to automate the filtering in cell A1. Not sure if a macro is the tool, or if there is another solution. I have only begun to explore macros so my knowledge is very limited.

Any assistance is greatly appreciated.

Thanks,

Chris