Can I have an intake form that fills in certain fields in multiple sheets?

Janelle

I have a sheet of all apparel information and a sheet of all staff information. I want to create a form that pulls the staff information and the piece of apparel they are taken into a separate sheet. I can than pull a report for who got what during a month.

My form would have the these fields: Staff number, apparel number