Excel 2003: I have a sheet that has 50 queries on it, when I use the Refersh button that is located with the Data Query Tool Bar it will refresh the whole Workbook and when made into a macro it looks like this:
Sub Refresh()
'
' Refresh Macro
' Macro recorded 4/7/2011 by Ken,  IPS
'

'
    ActiveWorkbook.RefreshAll
End Sub
What I need to know is can it be written so that instead of the Whole Workbook Refreshing it goes at one time, I saw this, and was wondering can I make that work for me. 

Sub Event1
refresh some item
End Sub
I don't know anything about writing code I just use the recorder, I saw this and was wondering can I write something that Refreshes each Data Query one at a time. They start at A6 on there is a query every 46 lines. I am about to start building 50 more queries on another sheet. When I am done I will have some where around 350 queries I don't think I want to refresh the whole workbook at once but rather set it up so one query refreshes and then it moves to the next, I just think I would get better results if it took its time rather than trying to get all at once. Right now there will usually be 5 or 6 queries that I get an Error on that Excel can not refresh but if i go the web site it is active, if I refresh that query individually it will refresh, so I am thinking I have too many at one time, so I need to slow the sheet down and tell it to do one at a time.

Thank you
Ken