Consolidating data from multiple worksheets

Hello All,

I need some help.

I have a workbook which has data in multiple tabs and also I have a macro which consolidates data from these tabs to one tab.(Master Tab name)

Everytime whenver I have to execute this macro first I have to delete the master tab and then execute the macro.

Is there a possibility where without deleting the tab can the data be consolidated.

Example: if I run the macro the data is consolidated, then I add data in tabs and run then re run the macro It should leave a row and then add the new data to master tab.

Also a last request can pivot be build on the master tab and auto refreshed when the macro is executed

I have attached the spreadsheet

Thanks in advance for all your support

Kamal