3 step consolidation.
 

one workbook with one master sheet and several other sheets.

1. Need to run macro "filldownid" on each sheet in workbook except
"master data".

2. Then for each worksheet.... Copy using this criteria. (must be
xldown from row 10 - no headers)

Range("A10:B10").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy

3. Paste this data to the next available row in "master data" sheet.

I have already tried Ron's code several times, but unfortunately I've
made so many ammendments to get what I want that I end up breaking the
whole darn thang to where nothing works.

Any help would be greatly appreciated.
Thanx