In Worksheet A, cell A3 I have the following formula: ='[File B.xlsx]Spreadsheet B'!$C5
In Worksheet A, cell A4 I would like to return the value that is ='[File B.xlsx]Spreadsheet B'!$C10
In Worksheet A , cell A5 I would like to return the value that is ='[File B.xlsx]Spreadsheet B'!$C15
This pattern will continue for many rows, incrementing 5 rows each time.

Looking for a way to write a formula I can copy down, so that I don't have to manually copy
and edit the cell reference on each line. Just not sure which excel function may help me do this.

Thank you for your assistance.