Copying Information To Multiple Cells And Updating Lists

ive had to retype this so please bear with me. ive utilised the resources of this site before but ive come to the time where i need to ask a question of my own.

now i will refer to my attached document as what im trying to achieve.

my project is to create membership cards for our social club at work, out of a list of people we have on our manifest.

If you refer to column A, this is where i will dump the manifest of members as time progresses (keeping in mind that more names will be added to this list as it goes).

What i am hoping to achieve, is to start at Cell A2 (highlighted in yellow). For the example the membership name is "a". i want to hit the macro button and the following will occur.

1. data "a" from Cell A2 will be copied to B2 (highlighted in green) and G6 (highlighted in blue). This moves the name from being on the unregistered list over to a membership card and to the registered list, which allows me to cross check that im not doubling up on names with new applicants and current members.

2. once this occurs, i was cell A2 to delete and cell A3 to be moved up, so now, cell A3's data "b" (highlighted in orange) will be moved to A2.

3. a similar process as point 1 will now occur, where A2 will be moved to the highest empty cell in Column B, which would be B3 now. It will also copy to G18 into the 2nd membership card.

4. this process occurs until column A is empty in A2.

5. i wish to really only have an A4 page worth of membership cards before i print, so i wish to be able to "reset" the membership card boxes, so that instead of the membership cards continuing all the way down the worksheet, it will do say 12, then print, then start back in the 1st box. Ideally this is a loop so that it occurs until there are no more names in Column A.

This is a huge feet for me as an idea because ive never gone beyond using basic recorded macros, however im the type who just HAS to learn how to do stuff, so i will lap up any information or assistance i can recieve from anyone here.