Ok-
I have a form template that employees fill out and then save with unique
names (i.e. template is saved as form.xlsx and they save it as form-1.xlsx,
etc). I also have a live spreadsheet that I want updated as employees fill
out the form. I know how to have cell A1 in book 2 equal cell C4 in book 1,
however what needs to happen is when employees fill out the form it
dynamically fills in the live spreadsheet. At the end of the day the
spreadsheet is "emptied" so it can be filled again the next day with new
information.

So basically what I want is to have the information on the form fill in the
spreadsheet and when another person fills out the form that information fills
in the next empty line in the live spreadsheet. Is this possible?
--
~one by one the penguins steal my sanity~