Master and Child sheets


Hi all,

Hoping someone can point me in the right direction?

I have a Candidate Recruitment Sheet where i am capturing key interview and recruitment data.

Once i am ready to hire the candidate I am wanting to have another sheet that references (from the MASTER sheet) only the candidates that are confirmed as HIRED, with only select fields from the Master sheet and then allows myself and other users to populate additional candidate personal info for payroll and tax purposes.

I have looked at the Copy workflow functionality but i dont want all of the data copied to the new sheet as it isnt all required. Thoughts on this?