Here are the details of The Excel Object Model of VBA. There is a specific syntax of connecting with Excel Workbook Objects from VBA. Some examples of Excel Objects are Workbook, Worksheet and Cells.

In VBA, cells are denoted as:
Cells (Row_no, Column_no).Value
You might have a question as to how the macro will know which worksheet we are referring to. So, we can write a more sheet-specific code as:
Sheets (“Sheet1”).Cells (Row_no, Column_no).Value
Please note that the sheet name should be in double quotes. Alternatively, we can also mention the sheet index number as 1, 2, 3, etc. (without double quotes), which would depend on the exact location of the worksheet. So, the code would be:
Sheets (1).Cells (Row_no, Column_no).Value