Brilliant! Thank you!

I have one more question... Sorry... I'm a complete newbie when it comes to VB and Excel.

I would like rows copied to seperate sheets within the same workbook... I have 25 sheets in total, each named with a room number... Ideally... I'd like a row which has information about the room G8 copied to the sheet G8 once the last selection has been made in column H. The same goes for any other rooms also. The idea is that each sheet will have a constantly growing list of entries for that particular room.