Excel Expert

Need help with VBA code to copy rows and columns with specific text to a separate work sheet. Info in tab A needs to go in tab B automatically or by button click. Specific text would be a name I select from column Z. Info copied would be from highlighted cells in row 4. For instance, if I put Carter's name into the code, all the columns that are highlighted and with Carter's name in column Z would be copied to tab B. Attached is example excel sheet.