Hi I am new to VBA just getting my bearings with it.

I am looking to create a summary sheet for a workbook that has various sheets.
The data in each sheet is mainly text.
I would like the summary sheet to mirror all the data that is in each of the separate sheets so that if any changes are made both change.
I currently have it coded so that my summary sheet clears then the sheets are copied and pasted on to it again when I click an active x button. This is working as a temporary fix but wondered if there was a neater way to do it.

Like I said very new to this so any help would be greatly appreciated.

Thanks