Reference another cell to complete a formula

Microsoft Office 2016

I would like a formula to be updated automatically when a new recipe is entered into another cell. For example..

='[STATISTICS.xlsm]WK-5-18EF'!$B$4

the WK-5-18ef would be a reference from another cell. Then if I was to change it to k-8-6 the formula would automatically become  ='[STATISTICS.xlsm]k-8-6'!$B$4

I have multiple sheets to make and this would be a massive time saver, plus I can forward it out onto other computers. I have tried INDIRECT and CELL functions but I haven't had any luck.

I have uploaded a sample file. The cell A5 would be what changes, and K6,k8,o6,o8,T1,t2,t3,w1 would all change accordingly. The formulas grab info from multiple sources. I appreciate any help you can give, thank you