I'm trying to out together a process where worksheets from a workbook are automatically emailed out on a morning and returned later in the day, complete with data to roll up into a consolidated format on one of the worksheets, within the workbook. I also ideally would like to individually password protect each worksheet. I know I have done this before using sharepoint but don't have that option this time. Does anyone have any ideas of the best way to achieve this?