Updating Excel Data from another spreadsheet

[JArchy]

Hi All,

I have included the spreadsheets below.

So in workbook 1, on Cell L15 we have a calculated % DT (Downtime) Due to Engineering column which is calculated using FILTER and SUM functions.

It would be great if I could get this figure pulled through weekly into Column C of Workbook 2, starting with Cell C175 being this current week (Week 16). When the number in Cell D15 is refreshed weekly I would like it to add the new number over into the Column C (Week 17, 18....)


Thanks for the Help,
Joel