Naming a Cell in Numbers
Numbers has some limitations when compared with Excel.

You can't reference sheets in a different Numbers file, for example.

The best you can do is to reference a cell withing the same file but on a different worksheet.  This works the same in Numbers as it does in Excel.

You can request this feature by using the Numbers Feedback form.