Have an individual employee report that I want to populate additional sheets

Hello,
I've been creating a standardized report that will be filled out by an individual employee that I would like to then populate sudsequent sheets, some that are sorted by Area and then one Master sheet with everything. Can I do this with VLOOKUP and COUNTIFs? Or some combination? Or do I need to learn VBA?
Thanks

Sure. Here's an employee form I wrote. Forms can feed, count, all kinds of things.

employee review.xlsm