macro to copy rows that are highlighted to another sheet 2

Hi

Was hoping someone could point me in the right direction

I have a spreadsheet that has a list of dates, names and Rooms (7 coloums).
At the moment i have a Cell in which i would type in Room 1 and it would highlight all the cells that have Room 1 in it (conditional Formatting)
Then i would open Sheet 1 and sheet 2 side by side and 'copy' & 'paste value' to sort each list into sorted lists.

Been stuck on creating a macro button that could do this copy the row which has a highligted cell and paste it into the cells i want it to.

Any help would be much appreciated

thankyou