How would I populate vales from columns A through G on several different worksheets into one master worksheet. Is it then possible to have that master worksheet update automatically should new values be placed into the other worksheets. I would never have more than 200 rows in each of the separate worksheets. I know a little about Excel but do not have time at the moment to learn if there is a particular formula, i.e. lookup, that would work best in this situation.