Single google sheet with multiple users access

[Ian Burger]

I'd like to add 10 odd users to a sheet and pull all of their data into the google woorkbook, each into a different sheet. Is this possible?

First challange seems to be that the user needs to run the request. Is it possible to change that? To be clear. I've got two users on now, for testing. When I run it it pulls my data and when the other user runs it it pulls his data into the sheet.