I'm not sure I understand your first question. I think the macro
could identify each group according to the numbers on the # column. I
don't want to include blank rows.

And yes I'm just appending each list to a master list. I don't need
any manipulation of data. The problem I have is that sometimes the
number of people in the lists  may be different. Another thing that
troubles me is that I have some columns between the ones I need. For
example in this table:

# USRID NAME D1 D2 D3 D4 TOTAL
1 545563 JANE 5.0 5.0 5.0 5.0 20.0
2 105654 MIKE 5.0 5.0 5.0 5.0 20.0
3 541586 STEVE 5.0 5.0 5.0 5.0 20.0
4 343423 MARK 5.0 5.0 5.0 5.0 20.0

I would only need the USRID, NAME, and TOTAL columns.