Excel VBA get range prices from historical stock prices

When you say:

One way would be to get needed data from those sheets and delete them but I think it is not the smartest way.

You mean you want all the data in sheet input ?
like
MSFT      1/1/2015      2/1/2015
should be 1 row only for this date range the
Open Price      Highest High      Lowest Low      Close Price

or it should be for every day during this period ?

Can you simply give us the real figures for these
MSFT      1/1/2015      2/1/2015
IBM              1/1/2015      2/1/2015
GOOG      1/1/2015      2/1/2015
GE              1/1/2015      2/1/2015

so we know how to go about doing the calculations ?
gowflow

What I need are Open Price, Highest High, Lowest Low, Close Price of specified date range for each Ticker.

I need to fill "yellow square" with data.
For example row for MSFT should look like:
Ticker      Start      End      Open Price      Highest High      Lowest Low      Close Price
MSFT      1/1/2015      2/1/2015      46.66      47.91      40.35      40.40



P.S.
I forgot to mention that I need it to work in MS Excel 2003.

yes ok pls test this file it will get you the values in Input sheet and will not create the sheets.
gowflow
Yahoo-V01.xlsm

Thank you.

Welcome