How to automatically create a variable number of rows on a linked sheet based on criteria

apmulheran 

I attempted this more as a challenge than anything else.  The output is an Excel Table with conditional formatting to create the borders.  There is an 'almost hidden' column that returns the primary guest name but allows it to overflow into the Guest Name column unless overwritten.  I have used Office 365 using XLOOKUP but I did also implement a solution with VLOOKUP just to remind myself of what a useless function it is!