Automatically copying every nth row to another Workbook

[tottieon]

I have 2 workbooks. No.1 calculates daily totals on every 5th line. Presently, this total has to be entered manually into Workbook 2.
I'd like No. 2 to update automatically every day. Any help appreciated. Thanks

[ChemistB]

So if your data is in Test.xlsx rows 3 to 220, In your other book

Please Login or Register  to view this content.

Copied across and down

[tottieon]

Thanks a lot, Chemist B. I had looked at the INDEX function but couldn't figure it out.