Spreadsheet With Multiple Data Sources

[leimst]

Hi,
I have a spreadsheet that is populated with data obtained from several other
spreadsheets and an .html document also. Is there a fairly simple and
efficient way to automate a process like that? It is a process that I will
have to perform monthly.

Thanks in advance,

Brian

 

[Nth]

Pivot table.
When you get to define the external data source you will be taken to MS
Query.
In MS Query you can link diferent tables (if they have a common field to use
as a key) and display consolidated data in your PT.

 

[leimst]

Will that work with the .html doc as well?

Pivot table.
When you get to define the external data source you will be taken to MS
Query.
In MS Query you can link diferent tables (if they have a common field to
use as a key) and display consolidated data in your PT.