Convert data from formula to text then jump to next row

I am new here and pretty much new to Excel, so any help is appreciated.
I have a workbook with two sheets: Sheet 2 (CustomerVehicleInfo) contains a client database. Sheet 1 is kind of a virtual work order where the mechanic enters the name of a client (in A1) and all his info pops up in cells B4-F4, according to Sheet 2.

I used a simple VLOOKUP for that:
=IF($A$1<>"",VLOOKUP($A$1,CustomerVehicleInfo!$A:$E,1),"")

Same formula for cells C4-F4.

Problem is that the client data needs to convert from a formula to static text and next time the mechanic enters a new name in A1 it needs to jump to the next row, starting at B5.

I hope all this makes sense and if anyone needs more info, please let me know.

Thanks a lot!

could it be coded in VBA to automate your request? if so, send a sample and you'll get the VBA macro in return

Sure, here you go.

i coded a simple automated macro that kicks in if cell A1 is changed

Works great, thank you!

just one last request, mark the post as solved and if you like add to my reputation (I'm thye wrong guy to ask that)