Hi there,

I have a workbook with 5 sheets which I would like to show all the
information from on a front sheet. The problem I have is that, although the
fields are the same, the length of the back sheets is constantly changing, so
I can't use a simple ref system. Is there anyway to set this up? I have tried
recording macros with no results as I had to specify copied ranges.

Any thoughts?