What I would like to accomplish is to have my aggregation-master-schedule-sheet (see context) put schedules in the same order that the sheets are. I.e. the left most sheet is 1st, the 2nd leftmost sheet is 2nd... from left-to-right ordered. It would be nice to drag the sheets into different orders and have the order reflected in the master-schedule.
Is there a way to either with code/gscript, or with a function/formula to return an integer value for a sheet? Or a another way to resolve this problem?
I created a google-workbook for sending schedules, such that per person receiving a schedule there is a sheet dedicated to that person's schedule only. THEN, there is a sheet that aggregates all of that information into a master-schedule that my supervisors use "out in the field" from their smartphones.