yogi_Merge Data From Several Sheets And Extract Only Unique Records

                                          Google Spreadsheet   Post  #869
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 13, 2012
user ChrisB87 said : (http://productforums.google.com/forum/?zx=4bgmt9q6qw83#!category-topic/docs/spreadsheets/atMJcawobxc)
Sorting data from multiple sheets
I want to gather data from several different sheets and compile all the data on one sheet and sort all data it by name. Below is a link to an example of what I want to do:

https://docs.google.com/a/vintage21.com/spreadsheet/ccc?key=0AlVXKDgtqFgedHJ4VVN0QkVZWTBnanUwUVZMUzl0QUE

I can provide clarification to what I'm trying to do if need be.

Thank you for any help!

----------------------------------------------------------------------------------

following is a solution using several helper column formulas