ExcelBanter - add information from multiple sheets into one box on another sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - add information from multiple sheets into one box on another sheet (https://www.excelbanter.com/excel-discussion-misc-queries/127052-add-information-multiple-sheets-into-one-box-another-sheet.html)

create button to unhide rows

add information from multiple sheets into one box on another sheet

I have numbers on a master sheet that when it is copied, i need to add a
number entered in the smae box on each new sheet to add into one box on
another sheet.

All times are GMT +1. The time now is 08:34 PM.