There isn't currently any functionality that would allow that, though someone may be able to write a macro to do it. I don't know anything about macros, so I really don't know. Something similar has been asked for before, such as a parametric note on the assembly sheet that would call out the sheet number of the part drawing.
Hi Glenn, at least I can stop searching for a function at the moment, though I'll have to get familiar with parametric notes as i'm still learning solidworks, Hopefully i'll find some better results in the future.
I've found an SPR that i think is exactly this:
for some reason i get an error when voting for it though...