I have an Excel spreadsheet that have separate tabs of worksheets with rows of information.

The concept is to have the information pulled from each separate worksheet into the main overview sheet.

Concern however is when these separate worksheets have had added/modified rows. How to ensure that the main page will reflect the additional rows?

The VLookup function will only pull from the range, so it will not pick up information that row is added and will push it out of the data range.

I am thinking of putting a macro, whereby there will be a button to use to add a row in each worksheet and also to add row in the main overview worksheet so that it tallies and references the information.

That is just the idea. Being incredibly new to VBA or creating macros, I dont have any idea on how to start writing it. This is the first time I have to do in Excel and VBA.

If there is anyone who could guide me the way, or give samples to create VBA scripts, your advices will be much welcomed and appreciated.

Thanks a lot