Hi all,
I am struggling with my VBA code at the moment trying to automate the task
of collecting data from several worksheets and placing it in one worksheet to
form one data Worksheet with all of the information. Every source Worksheet
has the same top header row record names but the number of records/rows in
each source Worksheet varies. Ideally the merged data would also sort into
order according to the content of column A or 1 in R1C1 reference.

Thanks for your time.
Geoff
England