G'day

Fisrtly, In NG Ettiquite, it's always nice to have someones name, so when
replying it personalises it. That said!

Take a look at this link, i'm fairly certain it will do what you need to
achieve.

http://www.rondebruin.nl/copy2.htm

This code will copy records from multiple sheets based on your criteria then
paste them to your designated target sheet.

Ron also has other example codes that may help you also.

HTH
Regards
Mark.