I am trying (unsuccessfully) in creating a formula, that will allow me to
total data from several workbooks, to a Summary sheet within Excel.

Does anyone know how to complete this?