I am familiar with EXCEL's "named ranges" ability to name a cell
something more meaningful like "sales" rather than let EXCEL default
it to "A1".

I am working on multiple woorkbooks with multiple tabs in each. When
I use a cell from one workbook in a calcualtion in another workbook I
get something like this:

F4*K4*N4*'C:\Documents\Project A\[Workbook A.xls]'SalesTab'!$A$2

My question is, can I rename all the gooble-de-gook 'C:\Documents
\Project A\[Workbook A.xls]'SalesTab' into something more meaningful
so my calculations in the cells do not get all cluttered with path and
woorkbook file names? Or at a minium shorten the gooble-de-gook
somehow?

Thanks.