Copy ranges and specific cells into one worksheet

Hello there,

I have been trying to play around with the VBA and realized that this code might be a little bit much for me. I need to copy different ranges from different sheets starting from one cell until it comes up empty. I would need the first range to copy to a specific cell into the master worksheet. The other ranges would need to copy underneath after the first range has completed copying I would need to do these for 6 sheets. Attached to these ranges I would need it to pull specific cells to paste to the next column dependent on these ranges.
Any help would be greatly appreciated!

I have attached a worksheet with comments to try to ease up confusion.

Thread posted in CS forum.

Asach,

You are duplicating efforts by posting in both the paid forum (Commercial services) and in the free forum. Your thread in the paid forum is still open. What do you intend to do with it?