As I said, your condition is wrong.
What is "of"? I could not see any cell in column A, in sheet Main? The code will loop through column A, but will return nothing as there is no row to match.
I see words like comman,ID, figures and etc, but not a word with "of"? on it.
It has to be like a asterisk then the word you are looking for and then possibly another asterisk