I have to process up to 125 worksheets with similar information every week
and then combine it into a master order form. The data I am compiling is very
basic, names, addresses, cost centers, etc. However, I cannot figure out
which formula to use to be able to gather these individual worksheets from
individual users and populate different rows, without overwriting the info,
on the master worksheet. Please help, I need to save hours of time!?!?!?