You can replace the reference with
INDIRECT("'G:\Accounting\_Acct\Facility\Allocation s\"&year(A1)&" Allocations\" &text(a1,"m-yyy")&"\["&text(a1,"m-yyy")& "Monthly Allocation & Fee Calculation.xlsx]Fee Summary'!$A$70:$H$78"

where A1 contains the date

( I hope I got that one right, but you've got the idea)
PS disregard the space in the first occurrence of " allocations", it's a forum bug

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post