[header] How to consolidate in excel [title] Verify that data in each worksheet appear in list format. [step] Make sure you have removed any blank columns and rows, and that each column is labeled with similar information. [substeps] Add and layout each column range to a separate worksheet. 
However, do not add the ranges to the master worksheet that you plan to consolidate. Highlight each range, and name them by picking the formulas tab, followed by the arrow located near name a range.