I would like to create a Master workbook that would allow me to return all necessary data from each worksheet added from my Room Template worksheet. I want to add (copy and rename the current "Room Template") the worksheet based on if there is a room name in "B" column. I have added my spreadsheet with notes explaining my current dilemma.
Bookmarks