So I want to have like data with the same categories on multiple worksheets (herefore referred to sub-worksheet(s)) compile onto one worksheet (master) without any space in-between.

-The problem is the amount of data changes daily on the sub-worksheets and there will not always be as many rows of data.

How do I put together an auto-updating list based on what's pasted with no spaces or overwriting?

Thank you so much for your help

-Bryan