Show Data from Various Tabs in one Tab within the same worksheet

[Ardy]

I still am working on my Teacher test result WorkBook. The problem I
am having now is transferring data from students tab to Roster tab, I
tried to explain this in my last post but I think I failed Due to No
response, no luck, so I am trying it again.

(Roster Tab- Sheet1)
A B C D E F G H Up To BM
1
2 Name1 Data Data Data Data Data
3 Name2
4 Name3
5 Up To
42
Name

(Name1 Tab - Sheet3) Sheet 2(Template) Is Hidden all Student tabs are
copy of Sheet2

Student Tabs are all have the same format. The data points are all the
same i.e Cell's F8, F14, G25 etc. My goal is to place a code or
formula in Either Roster Tab-Sheet1 or the respected cells to show
these data points for each student, sort of overall look. So the Info
in Cell F8 of the student tab should be reflected in cell C2 of the
roster Tab =(StudentName!F8).

Any Idea of approach.

 

[Ardy]

Hi Alok
It gives me an #REF! Error..........
http://www.pesare-darya.com/images/error-1.jpg
Ardy

 

[Ardy]

Works Like A charm,
I think I will incorporate this within my create student tab function,


Thanks a bunch.