pull data from one workbook to another in a running list manner

I have attached the two files I will be working with, and have listed the code I am using below as reference (trying to adapt code) and I am surely lost as to what changes I need to make.

I need the information from columns B, AF, AN, AO, & AW from cal ref.xlsx to go to columns C, D, E,B, & F in payment macro.xlsm respectively.
Currently I have (with code below) where the information will pull when I enter in the POS REF into cell A4 and fill in the row's data. I need it to fill the information into the row where I enter the POS REF in column A.

Please Login or Register  to view this content.

Originally Posted by xladept

There is no attachment

Sorry I guess I didn't do something right the first time.

Thank you, This is exactly what I need!!