Summing accross sheets

Hi,

I would like a formula which pulls in data across a number of sheets and returns it to the summary sheet.

Ideally I would like a formula to look across all workbooks and then match the following:
The Network name from column K
“Cost” with row 6
“Overall Result” in row 3

This is because the total are in different columns in different sheets.

Can sumproduct be used with a named ranged?

The obvious thing for me to do is to change and fix the total column on each sheet but this isn’t possible.

Can anyone help

Summing across sheets