I currently have a cell that references to a workbook by:

='P:\Tools\Transient Pickup Tool\ATLDO\ATLDO Pickup Tool 1.0.5.xlsm'!DaysLoaded

I would like to make it so that ATLDO is just referring to cell A2 so something like:

='P:\Tools\Transient Pickup Tool\" & A2 & "\XXXXX Pickup Tool 1.0.5.xlsm'!DaysLoaded

I would like to be able to drag it down a list without having to change each one individually. Where XXXXX is I would be referring to a cell. So 2 locations I'm trying to change.