I am trying to implement your idea. The issue I have is that the headings are not all the same and when they are they are not the same number.
The common heading in <Line Items> table and <Payments> table is the [reservation] heading, which is not the same in the <Reservations> table. The heading for the same number is [id]
<Line Items> table, column (G1)
<Payments> table, column (O1)
<Reservations> table, column (I1)
I know Excel fairly well, and in addition to the fact that the columns for the heading [reservation] and [id] are not the same, the number of rows for each table for each [reservation]/[id] are also not the same in numbers.
While I can Consolidate and use the VLookup function on these tables, it appears it would have to be done over and over, each time I would want to make sense of the numbers, create graphs etc.
Open to suggestions.