accessing variable sheet ranges within Google spreadsheet?

Question

I've been trying to keep this little project entirely within Google docs, but I may have hit a wall. The spreadsheet is being used as a way for multiple users to record individual events with a Template they duplicate. I want to be able to compile a list of names of those attended onto a "report" sheet from all of the unique sheets, which should be after a certain sheet index [3] to [infinite].

Is this sort of variable sheet range possible in Google spreadsheets or do I need to go to the API to get this accomplished?

Answer 1

Did you meant a way to goto the next sheet? Try this if you are looking for navigating to another tab.

1. navigate to 1st sheet ( #gid=0) =HYPERLINK( "http://spreadsheets.google.com/ccc?key=0AqFKYC9yujbTdE5lNVd2RLWeNwMQHpNSGdKRFE&hl=en#gid=0" ; "Sheet 1" )

=HYPERLINK( "http://spreadsheets.google.com/ccc?key=0AqFKYC9yujbTdE5lNVd2RLWeNwMQHpNSGdKRFE&hl=en#gid=1" ; "Sheet 2" )

=HYPERLINK( "http://spreadsheets.google.com/ccc?key=0AqFKYC9yujbTdE5lNVd2RLWeNwMQHpNSGdKRFE&hl=en#gid=2" ; "Sheet 3" )

Please note I have changed the #gid values on the end of the link. I have used HYPERLINK function also