I use smart tags in excel to track my stocks. Before using smart tages, I
used to bring in data using yahoo. But smart tags pulls their quotes from
MSN Money, which is fine by me.

The problem is I have many many spreadsheets, and MSN Money lets me refresh
the quotes every five minutes. Great if it is all on one worksheet. Not
great if you use many many worksheets.

I tried tying the multiple worksheets together into one master worksheet,
with all the info carried over form the first sheet to the larger one, but
found they would not update the latest prices, unless the "smart tag" stocks
were updated everywhere. Which means I've gotta hit "update quotes" and then
wait 4:57 seconds until I can proceed to the next sheet!

Is there some "master switch" I can throw to get all stocks in every
worksheet updated, even if it's once/day, say at 6 pm or 9 am, or anytime?

Thanks in advance. Switching to yahoo quotes is not an option. I have 200
worksheets. Yup, 200.