autofill a formula that references worksheet tabs

Hi there,

I currently have a very simple formula that brings in data from another tab within the same worksheet:

='JN0001'!C$3$

[where JN0001 is the tab name, and C3 the cell being referenced.]

Is there a way to amend this formula, or a function in Excel, so that when I drag down/autofill down it only changes the tab name (i.e. becomes ='JN0002'!C$3$, then ='JN0003'!C$3$, etc...)?

Many thanks
M