I have attached an example spreadsheet that shows the result using INDIRECT and OFFSET equations as well as the result I am trying to produce. Thanks.

IndirectRangeReference.xlsx