Hi Mark,

To fill data in one cell in one sheet across multiple sheets, you can use the "Fill Across Worksheets" feature in Excel. Here are the steps to do it:

1. Select the cell that contains the data you want to fill across multiple sheets.
2. Right-click on the selected cell and choose "Format Cells" from the context menu.
3. In the "Format Cells" dialog box, go to the "Alignment" tab and check the "Merge cells" checkbox. Click "OK" to close the dialog box.
4. Now, select all the sheets where you want to fill the data. You can do this by holding down the "Ctrl" key and clicking on the sheet tabs.
5. In the first sheet, enter the data in the merged cell.
6. Right-click on the sheet tab and choose "Select All Sheets" from the context menu.
7. Go to the merged cell in the first sheet and click on it to select it.
8. Press "Ctrl+D" to fill the data across all the selected sheets.

To create a list of all these totals in a separate sheet, you can use the "SUM" function with the "3D reference" feature in Excel. Here are the steps to do it:

1. Go to the sheet where you want to create the list of totals.
2. In the cell where you want to display the total, enter the following formula:
   Formula:

   "=SUM(1:3!A10)" 

   .
   Note: Replace
   Formula:

   "1:3" 

   with the sheet names where you have the totals and
   Formula:

   "A10" 

   with the cell reference where you have the totals.
3. Press "Enter" to calculate the total.
4. Now, you can copy the formula to other cells to display the totals for other cells.