copying data from various sheets to a Team Sheet

[In-Venutus]

I'm trying to add numerical data contained in a set number of cells from various sheets to a 'Team' sheet. Each of the sheets have various names so i wanted to use the numerical value of the sheets. Also the number of sheets in the Workbook changes as named Sheets are added and deleted.
Sheet 'Team' = Sheet1 & Sheet 'Perf' = Sheet2 are the only perminant sheets. 'Perf' does not have any data taken from it nor added to it.

The Code that i set up is:

Please Login or Register  to view this content.

Unfortunately it doesnt work. I think my problem is that i'm refering to the name of the sheets opposed to the numerical value.

[StephenR]

How does it not work? What happens - do you get an error, does it do nothing, does it do the wrong thing?

[In-Venutus]

There is a Run-Time error '1004'
Select Method of Range class failed

This happens on line :

Please Login or Register  to view this content.

[stanleydgromjr]

In-Venutus,


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Please Login or Register  to view this content.

[StephenR]

Stanley has probably already solved your problem but see if this works - the Selects may have been messing things up.

Please Login or Register  to view this content.

[In-Venutus]

Thanks for your help. It seems ok now