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.