Combine multiple ranges into one worksheet

[Troy Man]

I have 5 data ranges on different worksheets that I need to combine into the
one worksheet for analysis purposes.

The ranges are formatted in the same columns but differing row lengths and
the row lengths may expand on a monthly basis.

Consolidation and pivot tables with multiple ranges are not working for me.

I have no knowledge of VBA at this stage.

 

[ShaneDevenshire]

Hi,

You should take a look at the Data, Consolidate command. If the first row
and first column have unique identifiers you can consolidate by using them.
Look this topic up in the help system to see if it meets your needs.