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.


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