Getting name from a worksheet

[Kingdbag]

Is there anyway to get a name from one of the tabbed worksheets and input that info into a cell?

example... I have a sheet called Spencer.. I'd like to take that name and input it in a cell a1 on sheet capital labor....

can this be done?

I see this

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

but that just gets the name of a tab and puts it within that tabs worksheet i need to get it over to another worksheet...

[Kingdbag]

i got it =)