you have not given complete information. what do you want? your sheets are not RAW sheets. you have already stated some pivot able in the second sheet and some filtering in the third sheet. Yo;u have also split the screen in the third sheet it would be easier to help you if the data is raw sheets and you explain what you want
all cosmetic changes may be made JUST BEFORE PRESENTATION TO YOUR BOSS OR USER.; (and not before the macros are written).



I presume you want the "open" price for the next day is to be filled in column H in sheet "E-mail data". you must be having some reason for naming this file like this
if you want open price of theose stocks then from where you would like to get. do you have already get some arrangement to get historical data. Perhaps you can get the IRET data for 7 Dec 2011 (G2 plus one day) from yahoo finance.
http://finance.yahoo.com/q/hp?s=IRET...=07&f=2011&g=d

in this webpage you see the name of the smbol IRET,the date 2011 7th day 11 means december because the month number starts form 0 for January
and g at the end is daily data;.

how you do it (if you have yahoo user id and password for any of their items like mail etc log in first )

open an excel sheet (2007)
click data
click import from web data (second icon from the left)
replace the existing web address to the above address and click go
when the data is downloaded click only the table you want by clicking yellow horizontal arrow and click IMPOT at the bottom and choose the cell where it is to be donwloaded
normallly A1 and click ok.
the data for 7th jan 11 will be downloaded and you can choose open price
a macro can be written changing the changeable in the web page like symbol and dates.

you can also download data into excel (open another sheet and download this data using "new web query")
do you want to download from yahoo finance or from some other data source

suggest post raw data sheets and explain.