How to Read the Data From an Excel Sheet Using VB Macros Coding. Excel sheets read data in cells using cell references, which are the addresses that identify each cell.