Creating a dynamic reactive sheet

I'm sure I may be asking for the moon - but it's worth a shot.
I work in a travel company and they require us to manually type out a quote sheet (format is barely there).

I wanted to make two tables that would speed things up.
The first table would have a table that has the following columns
Day & Date / Category / Arrangement / Unit Price / Quantity / Total / Remarks & Comments

I had C5 and E5 hold start and end dates and then had a macro basically populate the table according to the number of days in the expected tour. Problem I found was that if I ever wanted to go back and edit or change those it would be borderline impossible.

The next table would basically read the category column and if it found for example (Category = Accommodation) it would extrapolate the data and populate it.
Repeat this for all subsequent categories.

My current method is using
=IFERROR(

IF(

FILTER(Quote[Arrangement], Quote[Category]='Information Reference'!A7)=0,

"",

FILTER(Quote[Arrangement], Quote[Category]='Information Reference'!A7)

),

""

)

Any guidance would be great.
I tried using ChatGPT to help guide me through it and started learning about Macros.
I kept running into a wall that it would sometimes update and then nuke the original table - without that table all references are lost and the entire thing implodes.