Join 6 Excelfiles from VW homepage

[OlaSa]

What is a good way to join these 6 Excel-files from internet (to one table) - with PowerQuery ?
Grateful for a few good tips.
Ola

[TABLE="width: 958"]
<tbody>[TR]
[TD]http://annualreport2014.volkswagena...nload.php?file=source_value_added_vw_ar14.xls[/TD]
[/TR]
[TR]
[TD]http://annualreport2012.volkswagena...nload.php?file=source_value_added_vw_ar12.xls[/TD]
[/TR]
[TR]
[TD]http://annualreport2010.volkswagena...nload.php?file=source_value_added_vw_ar10.xls[/TD]
[/TR]
[TR]
[TD]http://annualreport2014.volkswagena...hp?file=appropriation_value_added_vw_ar14.xls[/TD]
[/TR]
[TR]
[TD]http://annualreport2012.volkswagena...hp?file=appropriation_value_added_vw_ar12.xls[/TD]
[/TR]
[TR]
[TD]http://annualreport2010.volkswagena...hp?file=appropriation_value_added_vw_ar10.xls[/TD]
[/TR]
</tbody>[/TABLE]

 

[Gordonik]

Can be PowerQuery, but annual reports used to be static for past periods. So used ones doesn't have to be refresh later. For me the best option is to build excel database, customize to your needs and then use it in Power Pivot model.

 

[OlaSa]

Gordonik, thanks for the reply.
I solved the problem with PowerQuery - as a challenge, for learning purpose.
But I agree, would have been quicker to copy paste all data.