I'm trying to find a way for one column in a seperate spreadsheet to be
automatically popualated by the text that is input onto another spreadsheet.
I am not taking data from one single spreadsheet but taking data from
several (100+) spreadsheets setup for individual users.
All of the user spreadsheets are the same and the data I need to tak is a
free format text entry that isn't mandatory.

Can anyone suggest a way to pull this information from the user spreadsheets
into another spreadsheet, it would need to ignore any blank information and
not overwrite information taken from the other spreadsheets. I'm using MS
Excel 97. While I have little knowlegde of VB i am willing to conceed that
this might only be possible via VB.

How the sheet is setup :

Column A | Date | Time | Query | Save | Scheme | Reason | Comments <-- Free
format

Data rows are row 3 to 1000

All suggestions are welcomed.