How to Collect Data From Multiple Sheets into One Summary Sheet
Range notation is used to refer to book, sheet, column and cell. User can put book, sheet, column and row info. in column or column label rows, and then concatenate these info. as strings to build range string, and prefix with == in cell formula to collect data from different books, sheets, columns and rows.
Watch on
