VB code for excel - consolidating reporting data in one W/book from multiple W/books

We have approximately 10 separate excel workbooks that our product and segment teams plan, budget and report in. Each of these workbooks has three identical worksheets (Activity, budget, analysis. What we want to do, is to create a VB code that is applied to a Master excel workbook (with identical worksheets)so it pulls any data entered in product/segment worksheets into the appropriate master worksheet (in the next available line).



Therefore:

When someone is in the Product Excel and enters information into the ‘Activity’ worksheet –that data is pulled through to the ‘Activity’ worksheet in the master exel in the next available line.

Then when someone is in the Product B Excel and enters information into the ‘Activity’ or 'Analysis' worksheet – that data is pulled through to the ‘Activity’ or 'Analysis' worksheet in the master exel in the next available line.

We have the spreadsheets set up, we just need to have them connecting.

Kind regards,

Matt Charlton