Copy and paste based on wording in cell

[excelhelp31120]

Hi everyone!

I want to create a button, that when pressed, it will do the following below:

1) Based on the wording "for a selection", I would like four columns to be copy and pasted onto another tab. It would start in tab 'A', then loop to the next tab 'B', and so forth.
a. This is tab CC' and what the arrow is pointing at would be on tab 'After'.

pic1.png

2) Next it goes to tab 'B', and finds "for a selection" and copies over applicable cells that match the header on the 'After' tab. Also note, it goes directly under what was copied from tab 'CC'.

pic2.png

3) Lastly, it will add the names of the tabs above appropriate criteria.

pic3.png
Thank you!