macro/vba using address function paste values

hello,

being new to vba/macro's i need your help, i have a worksheet that i have vlookups in, these look at a master sheet and return the results, the macro i need takes the formulas and returns the values of the cells (this creates a permanent record) then copy the formulas into the blank cells below so it can start again.

i have attached an example of what i need, hopefully someone can help, if you need anymore info, please let me know.

many thanks reg