Populating many sheets from one [Closed]


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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!