Excel Help - apply same filter across multiple sheets.

[willhub]

Hi.

At work I do team stats, and currently the system we use had each day's stats on a sheet, the thing is it's the whole floor, not just my team, so on each sheet I have to individually filter out the names of my team, then repeat on a different sheet, this adds extra time.

Is there a way to auto apply this filter for my team on every single sheet, without using any special addons (because work computer won't allow it)

Thanks.

 

[willhub]

So a new sheet just gets added for every day. Each sheet is a day's worth it stats, and yes these stats do change. sometimes there are delays and instead of just doing the previous days I need to go through up to 7 days.