Project - Forms Data Compilation
 

Let me briefly describe my project. I have a number of forms; between them
they have some common and some unique pieces of data. Within a workbook, I
want to create a separate worksheet for each form to record its
data/properties. Then, from each worksheet created, have certain of the data
from each form automatically drop down into a summary listing of all forms
(one line per form) and their data/properties.

I know how to link info between worksheets, but how do I automate the
summary. If anyone can point me in the right direction I would sicerely
appreciate it. Thank you in advance.