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?