I have 1 workbook that contains about 20 worksheets.

worksheet 1 contains:
  • column headers
  • data

all other worksheets contain:
  • data


The data is formatted the same on all worksheets, meaning for example, column A = fruits, column B = city etc...

How can I combine all worksheets to fit on 1 sheet?

Thank you