inserting rows and/or columns on linked spreadsheets

[Guest]

I need to have data from several smaller spreadsheets feed into one large spreadsheet. The problem I'm having is that when I need to insert a row or a column into the source spreadsheet, they do not appear in the dependent spreadsheet. Is it possible to insert rows and/or column in linked spreadsheets. The information would be a combination of text and numbers.