Modify code to reference from a Matching value in Combobox1

[Corey]

Can anyone help me modify the below code ?
I want to have the highlighted line to refer to a matching value in sheet6
column A with the value selected in combobox1.



Dim i As Long
With workSheets(1).Range("N1") ' <============== Want this range to be
the value that was selected from the combobox. This value was from
sheet6(A:A).
.Offset(i, 0).Value = workSheets(i).Name
.Offset(i, 1).Value = workSheets(i).Range("B3").Value
.Offset(i, 2).Value = workSheets(i).Range("Z48").Value
.Offset(i, 3).Value = workSheets(i).Range("V3").Value
.Offset(i, 4).Value = workSheets(i).Range("J59").Value
End With

I want to be able to use this Cell as a reference from for OTHER data as the
rest of the code seems to do.

IE.
I can then get the value that is ((Offset(1, 4) for example )) from that
combobox value in sheet6 column A.

etc..............


Can anyone assist me with starting this?


Corey....