Auto-populate File Name into Formula for Linking Workbooks

Thanks for any help on this. I have attached 2 lines from my spread sheet as an example.

I want to drag these formulas down and have the file name fill in automatically. There are hundreds of file names that I already have on the sheet in column A.

The sample has the file name "CHb200-900-0 N2 01 mgmL 10 uL 20 mVs 1600 RPM Trial 1" in A1, and B2 has the formula:
='Mike''s HD:Users:mhrobson:Dropbox:XLabII:CHb200-900:Excel Files:[CHb200-900-0 N2 01 mgmL 10 uL 20 mVs 1600 RPM Trial 1.xlsx]Data Entry'!$A$2

If the next file name is "CHb200-900-0 N2 01 mgmL 10 uL 20 mVs 1600 RPM Trial 2", I want that file name to fill in in B3, and the next file name in B4, etc. Thanks!