Drag down formula for referencing sequential cells in another workbook

This may be really simple but I'm not great with Excel (yet!)

I have a weekly total in one workbook which will appear every 7th row (H7, H14, H21, etc.). This needs to be referenced in another workbook in a column in sequential cells (D3, D4, D5, etc.).

Short of adding in a link for every cell is there a formula I can use to put in the first cell and drag down to populate subsequent cells?

Please and Thank You