looping calculation in 4 sheets

hey everyone...my pblm is a bit big..so i need really an xpert help.

Description:

1. i have 5 sheets named SPECS, PULL, MATCH, SUMMARY1 & SUMMARY2 in order.
2.in SPCES i input some values...those values get reflected in PULL sheet.in PULL sheet certain formulas & programming is done to calculate a value.I have made a button in PULL sheet which copies all the inputs & outputs to the SUMMARY1 sheet.
3.next, i go to MATCH sheet (takes inputs from PULL sheet) & click a button to add inputs & outputs to the SUMMARY2 sheet.
4.in PULL sheet i select the speed (an input) say 1 {from the drop down menu (data validation) i have created} & add data to SUMMARY1 den i do the whole above mentioned procedure of step 3
next time i select speed 2 & repeat the above procedure.
den i select 3 nd so on upto lets say 10 times.
finally a chart is generated using the outputs corresponding to 10 different speeds.

What I want

i wish to have a code which automatically got to PULL sheet select speed 1 from the drop down menu adds data to SUMMARY1 go to MATCH sheet adds data to SUMMARY2...then go to PULL sheet select speed 2 & repeats the procedure lets say 10 times.
can this be done ??


Please look into my problem patiently and rply soon.

Thanx in advance




Bhasker

Assume that your data validation in PULL sheet in range A1
then the code will be (change the code as per your requirement)

Sub Test()
For x = 1 To 10
    Sheets("PULL").Select
    Range("A1") = x
    Call AddData1  '<-- Assume AddData1 is the macro name which adds data to SUMMARY1
    Sheets("MATCH").Select
    Call AddData2  '<-- Assume AddData2 is the macro name which adds data to SUMMARY2
Next x

hey sadath,...thanx 4 ur concern...
the data validation in range A1 takes values from say P1:P10
next, lets say P1 is selected, then values in 2 cells below range A1 (A2 & A3) also changes according to data validation cell value.
so how to tackle this ?