HLookup - Incremental Row additions

[RO24]

Afternoon - I looked and didn't see an incremental row increase request, so I'm posting it here.

I'm updating targets for Q1-Q4 and Fiscal year, which are a total of 6 rows (one in between Q4 and FY). I have 150 managers in my main file, but how can I show for rep 04, all of their targets for Q1-FY, and then follow up with the remaining reps throughout the workbook, without having to manually change the row number?

I've seen various options with the "Row" Function, but for whatever reason, it won't automatically populate throughout the sheet (I think it's because I have 5 separate rows for a single rep before I get to the next rep).

Thank you for any help. File Attached

rO