Is it possible to merge several sheets information into one sheet. All sheet have the same format of information. But they are in different sheet. eg. sheets called age 4, age 5 , age 6, age 7......so on. Each sheet contains
column 1 - Ref No.
column 2 - Name
column 3 - points gained.

Need to have all information in one sheet, so I can sort out which ever order I want. I want to avoid copy and paste, it takes ages.
Can anyone help please?

- Mahen