Is there any way i can make the function

=VLOOKUP(O9,'C:\Documents and Settings\robic9\My Documents\Gregory -
DRE24\Work Packs\[Gregory DRE24 Service Order
Summary.xls]Sheet1'!$A$8:$E$182,4)

look like this

=VLOOKUP(O9,'\Work Packs\[Service Order Summary.xls]Sheet1'!$A$8:$E$182,4)

and still work. I want to have the one summarry sheet in the root of one
directory and all spreadsheets with the lookup function to keep the lookup to
the root kind of like a web page where you have the root and you never have
to input the whole directory structure