Excel spreadsheet filtering

Hi. I have a spreadsheet which I need programming to allow me to filter.

Ok, so you want to create a tab/sheet for each building and pull relevant data from the main sheet into each building sheet, right?

also want the functionality to auto update each building sheet data when the main data sheet is updated each week