Vlookup with Index and Match, selecting from a single table of multiple tables

I'm struggling to find a solution for a formula to pull data from a specific table where there are multiple tables in a single worksheet. The example is, each table is a pay chart corresponding to a given year for operating specific equipment. The tables are organized by the equipment in column A, then across from column B, C, D etc would be the year of employment such as YR1 YR2 YR3 etc. You would then find your equipment row from column A and intersect to the corresponding employment year column to find your pay rate. Each table is formatted the same, but each table's money rates are different from year to year ie table 1 is for 2024, table 2 is for 2025, table 3 is for 2026. I currently have a formula using vlookup, index, and match that works for a single table, but I'm looking to find the pay rate for a specific equipment by entering a date in a separate cell (say A1 from another worksheet), comparing that date to the date of hire (determining the year of employment column), then using that first date entered (A1 from the other worksheet) to determine which yearly pay table to pull the data from. Thanks for the help!