Excel Name references to absolute sheet, how to make it relative

in workbook scope

in sheet1 I define name Test = B1, then excel automatically makes it as She开发者_如何学运维et1!B1. now when I use the name in sheet 2. I am expecting that it would refer to B1 in sheet 2 instead of Sheet1!B1. How could I do that?

---

You can refer to !$A$1, this will refer to the current Worksheet.

Regards,