Is there any decent way, where i can amend and import data on an existing powerpivot table from multimple excel worksheet?

[samihuq]

Hi There,
My Question is "Is there any decent way, where i can amend and import data on an existing powerpivot table from multimple excel worksheet?"

Background: I have started a large project in PowerPivot and got stuck in one silly problem.

I have a a workbook with say about 36 worksheets [Eg Jan 2008, Feb 2008....Jan 2009, Feb 2009...Jan 2010...Dec 2010] each with same structure [10 Columns] containing 100,000 rows on each sheet.

Now i am trying to consolidate all of them and trying to import them in a PowerPivot table for yearly analysis but whenever i am trying to link each sheet it is creating a different linked table. How can i accommodate all of them in one single table? You know what i mean to say.

Yes, i know i can copy each sheet and then use the paste append one after another, but on that case if any of my source data changes then i will not be able to reflect it in the power pivot correctly.

I can copy all of them in a note pad and can import it but then again i will loose the flexibility of Excel for Changing data.

So is there any other decent way, where i can amend and import data on an existing power pivot table from multiple excel worksheet?

I really really look forward for this annoying problem.

Regards,
Sami