I have a workbook that lists current employees on one spreadsheet and
terminated employees on another. I want to combine all of this
information on one spreadsheet within the same workbook without having
to cut and paste the information to the "All Up" spreadsheet.

Thanks in advance.