Get Value From Excel Sheet2

Can anybody help?

I have a simple excel spreadsheet that I am going to link to SolidWorks, eventually!

I have Sheet1 & Sheet2 in the spreadsheet.

In Sheet2 I have a value of 23 in cell A1 (For testing only!)

I need to bring this value, from cell A1, in Sheet2 to cell A1, in sheet1 (Again, just for testing)

Can anybody attach a spreadsheet that does this as I am struggling with "Vlookup"???

Many thanks in advance!

Darren

SolidworksApi/macros