Copy cells entered in sheets to form a single list in another

Closed
Posts
1
Registration date
Saturday September 9, 2017
Status
Member
Last seen
September 9, 2017
-
Hello,
I have a cells in sheets in Excel that I wish, as data is entered, to copy to another sheet and build a list from these entries. i.e. as data is entered onto the first sheets they copy to a single column in another sheet. The object is to collect the entered data form the first sheets, and list these in a combined sheet so that the data can be added and then averaged.
I know how to copy data from one sheets to another etc, it is the forming of a single, updating list in the combined sheet I need help with.

Any help?
Thank you
Alan