Macro Copy/Save active worksheet into a pre-existing workbook & rename sheet to cell data

Hello,
I'm needing help with a macro. I'm looking to copy/save a worksheet called "Reservations" into an existing workbook called "Reservation". Before it does this I will need the sheet to rename itself to text form cell B5. But I will need to be able to do this over and over again, always putting the copy/save sheet into the "Reservation" workbook with a new name of course from the text in cell B5. Hope I've made since of this. Any help would be greatly appreciated. I've been stumped on this for days.