I'm trying to get a Master workbook to view 10 different workbooks. Each of the 10 workbooks contain only 1 sheet that has identical column headers in the same order (left to right). Each row has different data, so I want the Master to view on 1 sheet each row from all 10 workbooks. Row 1 on the Master should display column headers. The master starting on row 2 then going down should display each of the 10 workbooks starting on row 2. For example, if each workbook has 11 rows (Row 1 is the column header) then the Master should have 101 rows total (Row 1 is the column header). I referred to Excel Help menu directions but still could not get it to work. I'm using Excel 2010.
Bookmarks