The function you need is INDIRECT.
--
David Biddulph

"Rich" (no spam) wrote in message
...
hiyais their a way to create a formula theat will look at a cell in
another
workbook where the file the form is stored in may alter

what want to do is have a cell with a value in , and the formula then link
to a sheet thats stored in said folder

I.e =c:\call b4\workbookname\page\cell

then file names within each folder are consistant its jut the FOLDER name
link am looking to locate via cell lookup

thanks