Forum Discussion

Raykay99's avatar
Raykay99
Copper Contributor
Jun 07, 2026

Summarising a number of sheets to a front sheet.

I have a simple spreadsheet with Sheets for individual investment details. The TABS contain the name of the investments eg BP

 

I am trying to put together the front sheet summarising certain data from the individual sheets, one row per sheet. Data such as Investment Name and Value.

 

How can I do this please?

1 Reply

  • How about this: support.microsoft.com/en-us/office/combine-data-from-multiple-sheets-dd7c7a2a-4648-4dbe-9a11-eedeba1546b4