Guys - Im really struggling with this on..

I am receiving 7 submission from different areas which I copy into different
tabs in a central workbook that I manage, what im looking to do is have a
consolidated view so a sheet that will pull all of the data from each
individual tab into one full list.

The problem I have is that the individual submission are constantly growing
in size so I am unable to reference to particular cells without leaving big
gaps in the summary tab