Hi

I have a daily template that is completed by some team members, this has to
be in a format that is easy to read and use for people not used to
spreadsheets.

However, I need to transfer the data to the main spreadsheet, in a different
format so that it can be used to generate reports. I want to use excel as
those that will be using the reports don't need to be trained.

The input sheet will have a unique date on the form, this is also already
present in the main workbook, and will act as the key to link the data
extracted to the correct location.

The data is in the form of an easy questionnaire, but needs to be translated
into a single row of information for each date. The format of the source and
destination will not change, but the data will need to be placed against the
date row of the destination sheet.

So the question is, how do I automatically transfer the information from the
first (remembering that there will be around 20 of these each month) to the
second (only ever one)?