Im really new here so apologize if this has been asked before.
My problem is this:

I have created a template file that will be stored on a share drive company
wide.
What I need is something that when someone uses that template, it will
create a unique number in a certain cell and then not change everytime the
new .xls file is opened.
I would like to have that number pull from 3 cells if possible.

I do understand a little bit about macros from what I have learned from this
discussion group. But please if its really complicated help me with step by
step.

Thank You