Sheet Filtering

[LouisT]

Hi Everyone, I'm trying to filter data from one tab to multiple tabs based on a specific value on Tab 1. In this case on a person's name. If the data in the row in question has a leader's name, then pull all that data in that row to the appropriate tab. There would be multiple columns to pull. I've thought of just using a Vlookup however i'm sure there's a more efficient formula.

any help would be appreciated.

Thanks in advance
LouisT