Hi everybody,
I have an sheet(main.xls) which comprises of the contents of two-three sheets(sub1,sub2.xls) by copying their contents and pasting one after the other.
Now, I want that if a change is made in one of the sub sheets(addition of some rows), then copy-paste procedure should run for that particular sub sheet in main sheet, other sub sheet's contents remainig untouched. Also since their is addtion of some rows in changed sub, so when that changed sub sheet is pasted in main sheet(updation of main sheet) the contents of sub sheets below the changed one, in main sheet should shift correspondingly downwards corresponding to the number of new rows in changed sub.

Hope, it is clear.
Kp