Please i'm doing the following several times weekly and it really takes time:
Each excel file has several sheets:

1- All pages landscape, margins 0.2, page size A4, one page width, add the content text of merged A1:A9 & C1:C9 cells.

2- Using the following format E7=VLOOKUP(B7,'Stateroom List'!$B$7:$O$100,4,FALSE) same used in F7=VLOOKUP(B7,'Stateroom List'!$B$7:$O$100,5,FALSE), then drag to E70 & F70.

3- Delete empty / merged rows except row a1 & c1.

Is there faster way.