Connect multiple similiar documents to create just one powerpivot

[ANCF]

Hello all,

I am trying to connect multiple excel documents (20 into total) into powerpivot (Excel 2010). They have the same structure, for example:

- Client, Item, Price, Amount.

The only variation is that each document is from a specific client.

So I want to use Powerpivot to collect all as database and just produce a single table with the description I told ( Client, Item, Price, Amount ).

Which is the best way to do this?

Thank you in advanced.

ANCF

[stasinek]

Hello, for me the easiest way is probably to use the POWER QUERY