Collect column from multiple tables

[Jake F]

I run a macro every two weeks to capture employee id numbers. This way we
can track the people at the company at that time. This has been collecting
since 2002 but we don't have a table/spreadsheet that has a collection of all
those ids to show when someone was hired and when they left to chart a trend
line of employee counts. I'm not sure if I can make a program to create a
table and collect the column from each of these table and maybe loop through
them all to pull the same column. The different table are unique by the run
date. Any help on the starting code would be greatly appreciated.

 

[nathan_savidge]

I am not sure i understand your point. Can you clarify if poss.