Creating static formatted report from imported data

Hi all

I'm hoping one of you can help me. i run a boat cruise business and the COTS booking software i use does not provide the reporting I need to create the cruise manifest. Each cruise has a manifest, there can be 10 cruises each week with up to 50 customer bookings (information set on a row) per manifest.

The current process is to copy and paste the data into Excel and run a macro to format. This would work well IF there were the same amount of data sets per cruise. Unfortunately since each cruise varies I must invoke the macro and then continue to format manually. This is extremely time consuming and introduces increased margin for error.

Is there a way to create a "template" that can be filled with data when the raw data is pasted into a separate worksheet? There are no mathematical equations required, it is simply a formatting exercise.

I have attached a sample of the data and the finished manifest I am tryng to create. Any assistance would be greatly appreciated.

Many thanks
Carol