Inserting pictures into an Excel cell using http// reference within a cell on a diff sheet in workbook

[brettf]

I'm using a workbook with multiple sheets of data...

Trying to insert pictures onto Sheet 1 (horizontally across a row - cells A1 thru F1) using external references found on Sheet 2 (located in vertically in Column A, rows 1 thru 6) - see below:

[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]http://www.trendmls.com/AssetLocator/getAsset.ashx?EntityType=Listing&AssetType=Image&BusinessPartnerID=1&ImageNumber=1&ImageVersion=LRG&MlsNumber=6092513[/TD]
[/TR]
[TR]
[TD]http://www.trendmls.com/AssetLocator/getAsset.ashx?EntityType=Listing&AssetType=Image&BusinessPartnerID=1&ImageNumber=1&ImageVersion=LRG&MlsNumber=6104375[/TD]
[/TR]
[TR]
[TD]http://www.trendmls.com/AssetLocator/getAsset.ashx?EntityType=Listing&AssetType=Image&BusinessPartnerID=1&ImageNumber=1&ImageVersion=LRG&MlsNumber=6107512[/TD]
[/TR]
[TR]
[TD]http://www.trendmls.com/AssetLocator/getAsset.ashx?EntityType=Listing&AssetType=Image&BusinessPartnerID=1&ImageNumber=1&ImageVersion=LRG&MlsNumber=6207986[/TD]
[/TR]
[TR]
[TD]http://www.trendmls.com/AssetLocator/getAsset.ashx?EntityType=Listing&AssetType=Image&BusinessPartnerID=1&ImageNumber=1&ImageVersion=LRG&MlsNumber=6216526[/TD]
[/TR]
[TR]
[TD]http://www.trendmls.com/AssetLocator/getAsset.ashx?EntityType=Listing&AssetType=Image&BusinessPartnerID=1&ImageNumber=1&ImageVersion=LRG&MlsNumber=6237933[/TD]
[/TR]
</tbody>[/TABLE]

Each "http" link is separately contained in a cell on Sheet 2 in Column A, rows 1 - 6; if hyperlinks are "clicked" - they currently open a picture in a separate window; I'm trying to auto-input their "picture output" into cells on the first row of Sheet 1...

i.e. Sheet 1 - cell A1 ("actual picture") should correlate to source data ("http://...") found in Sheet2 cell A1; Sheet 1 - cell B1 ("actual picture") should correlate to source data ("http://...") found in Sheet2 cell A2

The one variable is that only cells on Sheet 1 should be filled (with a picture) if there is a reference on Sheet 2; for example, if only cells A1 through A4 contain external source data (i.e. A5 and A6 are empty or "0") - then only the corresponding cells on Sheet 1 should contain pictures (i.e. A1, B1, C1 & D1) while cells E1 and F1 should remain blank or empty...

Is this possible?

Can anyone help me to create this macro/picture bridge?

I'm inexperienced w/macros & visual-b - have tried some hyperlinking, etc. as well as some macros - but continue to have difficulty with creating consistent, efficient output and/or macros that do not require debugging.

Many thanks in advance!

BrettF