All I need to know is how do I name a cell after a tab? i.e.

cell a2 = tab name

If you mean having the sheet name in the cell, one way is the formula:
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)

You have to save the file before the formula can work.