I'm looking for tips on how to how to automate a task I frequently do.

Here's the scenario:

I want to open a spreadsheet and when that sheet opens I want it to
read the first tab of 5 diferent spreadsheets and then stack them
vertically one after the other.

I've been able to get this partially implemented by placing formulas
in the cells in the target spreadsheet that go out and import the
contents from the five different spreadsheets but here are the
problems I would still like to overcome:

1) The number of rows in the five source spreadsheets can vary from
time to time and I would like to avoid having large blank areas
between the stacked results.

2) Importing the info from the other spreadsheets only brings the cell
contents, I would like to bring the formating info along with the
contents.

Any suggestions on how to address these two itmes would be greatly
appreciated!


John Keith