Need Help with Excel (copying consistant file path)

[sklok]

I need some help with automatically replacing file path in conistant cells.

Currently I have the following:
='M:\Tom 411\Company Plan\Results\[Year 3 Q1.xls]Production- Sales'!$E$10

This is in Cell C1

='M:\Tom 411\Company Plan\Results\[Year 3 Q2.xls]Production- Sales'!$E$10

This is in Cell D1

='M:\Tom 411\Company Plan\Results\[Year 3 Q3.xls]Production- Sales'!$E$10

This is in Cell E1

='M:\Tom 411\Company Plan\Results\[Year 3 Q4.xls]Production- Sales'!$E$10

This is in Cell F1

I want it to be able to drag from cell C1 to cell F1, and automatically changes to [Year 3 Q2.xls] in cell D1, [Year 3 Q3.xls] in cell E1, and [Year 3 Q4.xls] in cell F1

Please HELP!!!!

Thanks!!!

 

[BrianB]

Edit/Replace is usually easiest.