excel - VLOOKUP with button click -

i'm trying write code button click perform vlookup.

sheet1 = payment form, sheet2 = global, sheet3 = details

button on sheet "payment form".

this code cells in global sheet,

o1 = =vlookup(ba,details!a:h,8,0)
p1 = =vlookup(ba,details!a:h,6,0)
q1 =vlookup(ba,details!a:h,5,0)

i need loop through rows amount can change each month, if match found perform vlookup, no match found, delete row details sheet.

for example: global, cell b1 = 27801. in details match found, above codes columns o, p & q. global, b2 = 27802. in details no matching record found, row deleted. continue row 3 & 4 ......

suggest put value in table more efficient (not enter in excel cell), need create table insert ->table. :
details :

global worksheet, need enter 1 row of formula, rest of rows in same column have same formula "style"
column o :=vlookup([column ba],table2[[#all],[column1]:[column8]],8,false)
column p :=vlookup([column ba],details!a:h,6,false)
column q :=vlookup([column ba],details!a:h,5,false)

remove unwanted row, filter out blanks value in columns do.