Hi

just joined so I hope this is in the right area.

I have a central excel workbook.

I have 5 remote workers that I need a daily report from. The report has about 7 fields to be answered.

When the remote workers send me their update for the day I want to update the central excel worksheet with all the new information.

Example

Central Sheet
Name Company Number Date


Remote Worker
Name Company Number Date


I want the remote workers information sheet to update the main excel workbook.


Can excel do this?

Any thoughts much appreciated