Create very sheets with select rows/columns from master data file

Hello. I'm brand new here and tried searching around for this but wasn't able to find anything. Any help would be much appreciated!

Basically I get a master Excel file on a regular basis that has one sheet in it with a couple thousand rows (each representing a person) and then about 50 columns representing attributes of those people. What I would like to do is set up a master file with several sheets in it, customized the way I'd like them, which then updates automatically every time I replace the master data file with new information. Could someone please help me with how to do this?

So for example, I might want a sheet that displays only the rows from the master data file that have a "gender" column value of "male" and an "age" column value of between 18 and 30 (inclusive). For that sheet, though, I don't want it to display all 50 attributes for each person--I just want the ones of my choosing. For example, I might want the sheet include the columns "name", "age", "email" and "phone". So the end product would mean I replace my master data file, open up my separate customized file and am presented with an updated list showing the name, age, email and phone for each male age 18 to 20. I would then have several other spreadsheets that do the same but with different characteristics. Is this possible?


Also, separate but related question: I need to create a PDF file from each of those custom sheets each time I've updated the master data file. Is there any speedy way to do this for all at once or do I need to click on each sheet and go through the print menu?


MANY THANKS!!!