Extracting data from large database with sub-headers and varying lines of data

[rgimmi]

Help from the Excel Gurus Needed!
As you’ll be able to tell, I’m a hotelier and not nearly versed enough in Excel.
The data is laid out as follows:

• Each set of information is broken down by "date”(shown in brackets in column D) and “Period” (meal period to describe but it’s identified as the word “Period”(shown in column B) – note that both columns include additional data
• Underneath each of the sub-headers, the individual transactions are listed with several different sets of info (table no. (column G), cover (H), food (I), beverage (J), etc)
• Each set is delimited by a row of pure strike-throughs --- ----, followed by a subtotal for the section
• After the subtotal, there’s an empty row, after which it starts again as shown above

I’m trying to achieve the following:

• Create some way of extracting by a) day, b) month, c) year, d) meal period per day, e) meal period per month, f) meal periods per year, the number of a) covers, b) food (revenue), c) beverage (revenue)
• Also trying to find instances where a table no. was used twice or more in one sub-segment (meal period)

If that doesn’t work, any way to add the “period” to an additional column in front of the data right underneath it as well as the “(Date)”. That way a fairly straight-forward SUMIFS or COUNTIFS could work.
Since I have already trouble trying to put it into words, imagine my challenge writing a formula for it.
The data load is fairly huge and for several areas, so I’m trying to avoid manual interaction as much as I can.
Thank you in advance for your thoughts