How to create a single view for 6 diff sheets for updating

i have a Google sheet with 6 seperate forms across 6 seperate sheets…

I have created a starting point by creating a link to take the user to the form, which will be filled over the course of day…

now i want to know how to create a view where in 1 place i can see all the forms across 6 sheets in single place, so the user can select any of the pending forms to update in the day.

how can i achieve that…

0 2 575
2 REPLIES 2
Top Labels in this Space