Wednesday, April 10, 2013

yogi_Summarize In yogi_Sheet1 Data For Different Attributes In Specified Rows Of Column A Of various Sheets Named Sequentially As Sheet2 Sheet3 Sheet4 and so on

                                          Google Spreadsheet   Post  #1107
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Apr 10, 2013
user Nathan S. :(!mydiscussions/docs/bbfPIo666Lo)
Increment Sheet with Autofill
I want to have my first sheet be a summary of the rest of my sheets. All the sheets except the first one would follow the exact same format and be for different groups. So for example I would want a column on sheet 1 that goes =Sheet2!A1,=Sheet3!A1,=Sheet4!A1 and so on. This way I can get a basic summary of all the sheets on one sheet and if I want more detailed I can go to the individual sheet. I was hoping there is some way I can auto fill this because none of the ways I've tried so far have worked.
It would looks something like this except it would have a lot more data. Notice that as you go down a column only the Sheet increments.
following is a solution to the problem based on your supplied data