Each month I receive a spreadsheet that contains among other things various lists typically 50 to 200 items long in the format

B12345
S23456
K98765

I would like to be able to join all these lists together into one long list and haven't been able to find an easy way to do this. Currently having to manually cut and paste each list to 'join' them together.

The lists wouldn't necessarily be in the same locations each month but I could get the columns alongside each other if that would help!

I couldn't see that Concatenate (which I am familiar with) or Consolidate (which I don't know) could help.

Is there another way please?