I have a spreadsheet that we use to keep a record of requests for
information. I have a workbook listing all requests over the last three
years. We would like to create a new workbook for each year. Without
copying and pasting, how can I have the new information that is requested
automatically be entered into the workbook for that corresponding workbook.
Any suggestions would be appreciated and thank you in advance for your time.