Copying Form Fields to Log
 

I have an Excel form file with 10 fields that I send to different
customers to complete. I can't link the cells because I am sending
them to outside companies.I would like to have a log that summerizes
all of my received files.

for example,
my form would look like this...

Name: Joe Smith Company: ABC Co
Address: 123 Oak
Description: Red, Green, Large
Amount: 10.50

my log file would look like this...

Name Company Address
Description Amount
Joe Smith ABC Co 123 Oak Red,
Green, Large 10.50
next form etc....

What would be the best way to write a mcaro to do this.

Thanks