VBA Help Please

[Potholes]

I have attached my shortened steps to achieve my final outcome

[QUOTE
Step 1" Sheet 3 " If Q6="",and L6="" select( D2, F2, J6,) vlookup "Sheet 1" (Cells A1:Z107 ) paste data from ( D2, F2, J6,)

then run clear open macro select "Sheet 3 " D6 OR



Step 2" Sheet 3 " If Q6="",and L6," V or W " select( D2, F2, L6,)(in this scenario ignore J6) vlookup "Sheet 1" (Cells A1:Z107 )

paste data from ( D2, F2, L6,) then run clear open macro select "Sheet 3 " D6 OR



Step3 " Sheet 3 " If Q6>"", select D6 & Q6, for pasting (Timeout column on sheet 1)" (refer structure on "Sheet 7" L8-L30)
then on "Sheet 1 "(In this case Column "J",(Cells A1:Z107 Paste Q6),then run clear open macro select "Sheet 3 " D6 [/QUOTE]







Cross posted elsewhere

Read ( FRONT ) page data then transfer that data to the main data Sheet (OPEN)



Attached are 2 sample files to assist with writing code.