need help with a macro to make certain text within the entire sheet BOLD

I need a better example of 6 sheets etc.

You could try to put this macro behind each pivot sheet. You will also need to have a sheet called BoldList in the workbook.