To stop the worksheet name from coming automatically while referring a cell or range of cells

arunmukherjee  Use a Named Range instead of just a cell reference. You'll find that under Inseert....Name. You can name a single cell or a whole table, and then refer to it simply by name in any formulas.

Here's a quick and dirty example. THere are two worksheets in the workbook. The first does a lookup and then a calculation based on references to the other sheet, but using the name of cell ("Tax") in one case and a range ("ProdTable") in the other.