Back Ground - I have a workbook that has two tabs (1, 2). Tab one
will be a user tab for inputting names in column A. I have (with help
from this group) a function that will create one tab for each one of
the names inserting the name as tab label and making a link from the
name to the respected tab(Code for this is available upon request) I
wanted to make this post short. Tab 2 which is a hidden tab is a
Template that all the newly created tabs are based off of. This will
give me data points (Cells) that are the same between all tabs. One of
my ultimate goal is to transfer all of needed data points (Cells) from
each tab to the tab number 1 in a linear fashion in front of each name.
Once I do that I can then create Graphs much easier via macros.

My Question: I need the data transfer to be dynamic because the number
of names and number of tabs could change from user to user. In another
word the code probably needs to see how many tabs there are then grab
the data from(name tab) to(Tab 1). If I have an example I probably can
modify if so All my From and To's work probably. I hope I explain
this adequately if not please ask questions........ I have a come
along way since start of this and thanks to you all for help up to now.

Ardy

I have this code from the recorder, How can I read the cell values in
column A starting A2 and insert it in place of Sheet3.

Range("D2").Select
ActiveCell.FormulaR1C1 = "=(Sheet3!R[6]C[2])"

Ardy wrote:
Back Ground - I have a workbook that has two tabs (1, 2). Tab one
will be a user tab for inputting names in column A. I have (with help
from this group) a function that will create one tab for each one of
the names inserting the name as tab label and making a link from the
name to the respected tab(Code for this is available upon request) I
wanted to make this post short. Tab 2 which is a hidden tab is a
Template that all the newly created tabs are based off of. This will
give me data points (Cells) that are the same between all tabs. One of
my ultimate goal is to transfer all of needed data points (Cells) from
each tab to the tab number 1 in a linear fashion in front of each name.
Once I do that I can then create Graphs much easier via macros.

My Question: I need the data transfer to be dynamic because the number
of names and number of tabs could change from user to user. In another
word the code probably needs to see how many tabs there are then grab
the data from(name tab) to(Tab 1). If I have an example I probably can
modify if so All my From and To's work probably. I hope I explain
this adequately if not please ask questions........ I have a come
along way since start of this and thanks to you all for help up to now.

Ardy