I am attempting to create a template worksheet that several different people will be independently working from, creating several different worksheets to be saved on a Windows network share drive. The template spreadsheet will contain approximately 8 columns of unique data utilizing no formulas. What I need is for the data from each of those worksheets to automatically populate a master worksheet on a daily basis. I am completely new to this, so I'm not sure if this can be accomplished from an excel formula, macro, or visual basic.

Thank you for any assistance this forum may provide.