Pulling specific rows from one row to another sheet

I work in events and I want to make a master production schedule that I can sort by location and various people that are working. This way I can do one master schedule and then just pull information from the master schedule and have a schedule just for the tent location and another schedule for the hotel location. I also want to be able to pull a schedule for each person that is working. That would be handy so I can hand a person a schedule of all of their duties.
I need some help undertanding the formula for this because I add and delete rows depending on how long/complex the event is, also I have events that will have 1 location or 10 locations.
I attached a sample schedule.

Any help would be appreciated.

Thanks

It will be good if you attach an output file showing how your output should look like.