Calculate the cost over a period but with multiple variables

I'm trying to calculate the cost over a period of time where the start and end are provided in two cells (e.g. F4 is the start date and G4 is the end date).
Sometimes the period between these two cells spans multiple financial years.
In another table I have hourly rates based on the financial year. The table also shows the total annual rate.
If the 2023-24 rate for the selected person is $64.16 (Q4), 2024-25 rate is $65.76 (S4) and 2025-26 is $67.40 (U4) and the date in F4 is 20-03-2023 and F5 is 16-03-2026, I need to factor in the hourly increase over the period defined in F4 and F5. The Resource Allocation table will also have the number of days and the number of hours. The only other variable is the name of the resource (column C). The name is in both the table where this calculation is to occur (L4) and the Resources and Annual Salary table with the hourly and annual rates.
Sample.xlsx

Is this even possible? If so, I would greatly appreciate anyone's help!

Cheers
Glen

Unfortunately no VBA but i could get away with Office Scripts if that works?
The financial year starts 1st July

That's ok, i appreciate your effort anyway!

Hi
That formula is some serious wizardry! Works perfectly (i'm sure you're not surprised).
Many hours of searching and trial and error got me nowhere so i really appreciate it.
I wholeheartedly, thank you and appreciate the clear explanation!