I have a spreadsheet with many (27) sheets where all the columns in each sheet are the same. I have created a dashboard using VSTACK to show all the data from all the sheets on a single page.

=VSTACK(Table1, Table2, Table3….Table27). Column G on the dashboard lists dues dates, and I would like to be able to sort the entire dashboard by column G. 

The end result should be a dashboard that shows all the data from all the sheets and lists the rows in chronological order according to column G. I have tried to add a SORT function in front of the VSTACK with no luck (produces a #VALUE! error). 

​I have a spreadsheet with many (27) sheets where all the columns in each sheet are the same. I have created a dashboard using VSTACK to show all the data from all the sheets on a single page.=VSTACK(Table1, Table2, Table3….Table27). Column G on the dashboard lists dues dates, and I would like to be able to sort the entire dashboard by column G.  The end result should be a dashboard that shows all the data from all the sheets and lists the rows in chronological order according to column G. I have tried to add a SORT function in front of the VSTACK with no luck (produces a #VALUE! error).   Read More

​