Hi Max,

I check your formula again and I've missed something. Please note that I've
12 primary worksheets + 1 Summary worksheet. Each primary worksheet has
different number of records and records in worksheets are ranging from 80 to
120. Are the number of worksheets and records are not suitable for your
formula? Please advise.

Sorry to bother you again.

Thanks & regards.

"Max" wrote:

"Freshman" wrote:
.. I want to copy every record in columns A, B & E
of every worksheet to the Summary worksheet then I use them
for analysis in a pivot table. Since the records are filled in month after
month, so I want the completed records of the current month can be
automatically copy to the row under the last record in the Summary worksheet,
i.e. May06's records under Apr06's record...

If the # of sheets to be auto-summarized isn't too many ..
say, data from up to 4 sheets to auto-stack into a summary sheet,
then one possible formulas play to achieve it could be along the lines
in this response to a similar query:

http://tinyurl.com/l7kst

The sample construct mentioned is available at:
http://www.savefile.com/files/4567345
Dynamic record selection from multiple worksheets.xls

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---