Populating many sheets from one

Elaine - Sep 29, 2016 at 01:10 PM

I'm working on a Google Excel doc which is being populated by entries on a Google form. Each row on the sheet relates to one form entry.

I'd like to self-populate a separate sheet for each row which will be easier for a committee to read. I have created the layout for the individual sheets and assigned which data from the main sheet fills each field, however changing it on each sheet takes a long time. Is there a way to designate each tab when I create it so that it auto-fills all of the correct data from the correct row on the main page?

Apologies if poorly explained.