ExcelBanter - VLOOKUP & Combining Worksheets

I have 3 worksheet that have 2 columns of "Inventory Items in Column A" and
"Inventory Available in Column B".

I have three sources where I pull the information from and I put them into
their own sole sheets (within the document)

I create sheet 4 as a JOINED list to compare inventory counts to the
inventory items.

The person who did this is no longer with us. I know she used VLOOKUP.

What I need is a code that I can put onto the JOINED sheet.

Here is a sample of what I need. Look through the 4 sheets.

<body
<p<a href="http://www.geocities.com/kittyblunts/Vlookup_SMPLE.xls/"Click
Here To View It</a</p
</body