Can I take data from one excel file, then copy that information into a new file or sheet?

Hi, I'm looking to see if there is a way to select keywords in a column that would then move information from a different cell into a new sheet or file.

What I want to do is try to get a job list of people and their company to move their names into company specific timesheets.

I think I want sheet 1 to have the staff list; sheet 2 to be the time sheet list of company a; sheet 3 to be the time sheet of company b.

I hope this makes sense.

I have been trying to research, and I think the IF formula may work, but I am a little rusty with excel, as haven't done anything complicated in many years.

Thanks for your help.