how to consolidate large worksheets w/ 800~1000 rows by category?
 

i have saved product sales information of the same month in one workbook-
each sheet represent sales from one of the 3 departments. After 3 years of
data collection, i now have 36 workbooks, each w/ 3 worksheets. However, i
don't have any collected data. I tried consolidate by category, but the
colomns did not merge correctly. Data were all over the place! Each sheet
has about 800~1000 data. How do I go about consolidate them so i can see
data by store for the year?
???