Excel formula

[wes2706]

I have an excel formula that looks like this....

='S:\Sales\Level 1\Daily Reporting\Daily Progress Report\[Bethel Daily Report - November 2017.xlsx]011117'!$M$16

But the word "Bethel" needs to be taken from a different cell B3, as it will vary each time.
Same with the phrase "November 2017" which comes from cell C4.


How can I automate this?

[SamT]

MAybe...
='S:\Sales\Level 1\Daily Reporting\Daily Progress Report\[&B3& Daily Report - &C4& 2017.xlsx]011117'!$M$16
: