17 xls files each has several sheets each has the same table. How to merge them in one?

[1tane1]

I sent the same blank table to 17 companies so that they can fill in their data.
I got data from 17 companies. Each company has different number of sheets. Each sheet gives information about their product. (Each sheet has different name) Let's say 150 sheets in total.

Now, I want to create a table where these 150 products' name are written on left column and their relative information are given on next columns.
Is there an easy way to merge them all??


For example, a sheet:

Blue Diamond
	2012	2013
Price	5$	6$
Tax	10%	11%

Big Table:

Name	Price	Price	Tax	Tax
	2012	2013	2012	2013
Blue Diamond	5$	6$	10%	11%
Red Diamond	6$	6$	15%	11%
YellowDiamond	2$	9$	20%	11%

[1tane1]

I can even combine all sheets into one sheet vertically. I found this code but it has a small error. It copy/paste every 3 rows instead of 14 (I want 14)

Please Login or Register  to view this content.

[1tane1]

This solution solved my problem: http://www.tarwara.info/merge-excel-...007-2010-2003/