Need help automatically insert rows with data from another spreadsheet in same excel file

Hi All,

ok, here goes.. I am trying to create an excel file with multiple sheets within named Main / Section1 / Section2. Main Sheet will be the spreadsheet compiling all data from spreadsheets Section1 and Section2. Is there any way to do it so that whenever new data is entered into Section1 and Section2, new rows with the new data will be automatically inserted into Main Spreadsheet without overwriting the existing data? Would really really appreciate if someone could help me out on this.

Many thanks.

Example:

main.jpg

sa.jpg

sb.jpg

Probably you do.

If you took the time reading some questions, you will have read that you get better help if you add an excel file, without confidentional information.

In that case also add the desired (expected) result.

Not sure about your question.

But see if the result on the sheet "consolidated" is what you want.

See the attached file.

I added an button on the consolidated sheet.

The whole sheet will update after pushing the button.

Try adding new row in sectionA (like i did) and push the button.

Please reply if this is what you're up to.

Thanks for the reply.

Glad i could help.

Dear Oeldere,

You gave a great solution to Songserene. thats very nice.
Actually i have the same problem to do with my worksheet please view my attached worksheet and oblige.

Abdul Rouf

@roofi,

according to the forumrules, you need to open an own question, and refer to this topic.

please also add the desired (expected) result in your sheet.

@songserene,

add manualy (in your workbook) how the result should be in sheet consolidation.