I am looking to be able to quickly combine 5 - 10 workbooks with 1 worksheet in each in to one consolidated table.
Additionally, I am looking for a workbook designed to take data in one table and copy a rows in the table to separate spreadsheets based on criteria in one of the cells. (i.e. one column has names in it. I want the row to copy to a template in the other sheets in the workbook based on the individual's name)