Hello,
I've been searching through the forums, but haven't found anything yet.
Does anyone know of a way to copy data from multiple worksheets (i.e. 30) to
one master form? I do NOT want to summarize the data, I want to replicate it
exactly, and have a live link so that if the individual sheets are changed,
the master will update. All column headings are identical, but there are
variable numbers of rows.

My only thoughts so far are simply typing =Sheet1!A2 and dragging, repeating
for each sheet (or I guess writing a macro to do this). However, if I insert
a new row on any of the sheets, it does not update. Any way to do this also?

Thanks in advance!