Need Help generating a and copying a chain of code.

Ok. So I created a formula to genterate from one program to the other. I am use to being able to click at drag the formula and have it create a new one such as 1,2,3,4,5. This formula is a little more complex and does not do that. Please help. Here is the formula.

='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]120913'!$N$6
='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]121013'!$N$6

When I highlight and drag them I want it to create 121113,121213, and so on. It just keeps creating

='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]120913'!$N$6
='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]121013'!$N$6
='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]120913'!$N$6
='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]121013'!$N$6
='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]120913'!$N$6
='C:\Documents and Settings\jmor08j\Desktop\[DAILYLOGSHEETS.xlsx]121013'!$N$6

Please help. What can I do?