Excel Formula Help or VB Alternative

[Randy11]

Have the following formula being used to append data from three separate worksheets into one list. All three worksheets have the same design exactly. i.e. same data entry range A1:A13 as an example. The formula below works great but am looking for an easier way. There are many more worksheets that need to be included. What I was hoping was to be able to name a range that includes the data entry feilds from all work sheets & sort this into an appended list with no blanks. The catch is they need to be placed in same order as keyed so a kill list can be generated. If not possible by formula, suspect there is VB coding that may help with this.
Assistance appreciated.

Formula is place in a collection sheet in the same number of cells that could have data entry in them.
=IF(IF(ROW()>COUNTA(aa)+COUNTA(ab),OFFSET(ba,ROW()-1-COUNTA(aa)-COUNTA(ab),0,1,1),IF(ROW()>COUNTA(aa),OFFSET(ab,ROW()-1-COUNTA(aa),0,1,1),OFFSET(aa,ROW()-1,0,1,1)))=0,"",IF(ROW()>COUNTA(aa)+COUNTA(ab),OFFSET(ba,ROW()-1-COUNTA(aa)-COUNTA(ab),0,1,1),IF(ROW()>COUNTA(aa),OFFSET(ab,ROW()-1-COUNTA(aa),0,1,1),OFFSET(aa,ROW()-1,0,1,1))))

 

[SkipVought]

hi,

Appending data to a table of list using formulas is a very poor choice of tools.

Why not use MS Query faq68-5829 jioning 3 queries with a UNION statement? There is no VBA and the SQL code is quite simple.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}