Hello Excel-ers!

I am working on automating an excel file and running into a ton of small problems which I am not able to really figure how to fix it.

Basically I have a Macro running perfectly for 1 single web querry. So in Short what it does is.
Takes an ID from the user, Imports the data for that ID from the web page. dumps it on a NEW SHEET. Finally OUTPUT SHEET Pulls out the data I require and presents it in a nice table.
This Works perfectly and the data is refreshed and copied to OUTPUT SHEET at regular Intervals (say 15min).

Not what I am trying to do is, Create an array (variant of size 10).

The user will input an ID. The macro fetches the data from the web. Dumps it on the a new sheet. These sheets should be stored as eg.
RAWDATA(1), RAWDATA(2),......RAWDATA(10) .
And Ofc I will have corresponding output sheets as
OUTPUT(1),OUTPUT(2).......OUTPUT(10).

So I can use command buttons (add new data etc) and obtain all these 20 sheets.

The problem I am having is I want to write a loop for this command button. where I am having some issues as I am using a counter 'i' but there is not a proper sub function that I can increment it.

Also I want the RAWDATA to be updated at regular time intervals (say 10min) and at the same time add a new row in the OUTPUT sheet and copy the data I want.
Here what happens is if I have 10 OUTPUT sheets, only the last one updates i.e. OUTPUT(10). all the other 9 stop updating, even though it is in a For/while loop i=1:10.

I hope my problem a bit clear?
If someone can throw some light please let me know.

If someone can spare some time please msg me, I can PM you the excel file.

Hope to hear soon.

Thanks guys.
Cheers