Linking worksheets to copy cells from 1 sheet to another

I'm trying to get a macro that updates 1 worksheet with information from another worksheet.

I've attached a sample spreadsheet. Basically this is for work. Supervisors (level 1) report to managers (level 2) who report to owner (level 3). Level 1 should only see their employee. Level 2 should see all the employees under them; that is, all the employees of the level 1 supervisors they're in charge of. Level 3 should see everyone.

How do I get level 2 and level 3 to automatically update with the information found in the sheets of level 1? I would like to maintain formatting throughout.

I'm attempting a different strategy here, this is why I did not link this post.