Copy rows from work sheets to combine to one work sheet based on cell value

thank you, thank you, thank you.

it works great.

this is my first experience with excelforum.com and it couldn't be any better.

cheers,
joe