How can I combine multiple sheets into one sheet?

Hi there!

I currently have 23 separate sheets, all with the same headers that are currently separated by location. I now want to combine all 23 sheets into one so that I can easily pull data from the sheets into a dashboard. How I can I combine the rows from each of these sheets into one sheet?

Best Answer

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    Answer ✓

    Hi @Weston Barnes,

    You could go into each sheet, select all rows, right-click and select "Copy to Another Sheet" or "Move to Another Sheet", and then select the sheet you want them moved or copied to. Do this for each sheet except for the one that everything is being copied into.

    Best of luck!

    BRgds,

    -Ray

Answers