Transfer info from one sheet to another
 

I am working on 3 different projects at the same time. It's no wonder I
can't think.
Anyway. I would like to pull information from one worksheet to another.
I would like perhaps a template that will pick up the info from what
ever sheet is in front of the template, and insert the info in the
desired cells, in the template. I think a template is what I want. in
short After I do a sort I want the info to rearrange itself on another
sheet so it's in the format the boss wants.
Is there a way to write a formula so it picks up the preceding page
info no matter what it's name is? Suggestions?


--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=520635