I'm looking for a macro that would automaitcally populate value entered in a cell in ColumnA in sheet1 in to other cells with a similarly named columns.

For example, if i enter a value in Cell A2 where Cell A1 is the column header ("Test"), then the macro should look for columns that contains the word "Test" and populate the value entered in Cell A1 below that column header wherever it finds the name "Test". There are multiple sheets in the same workbook that contains the column header test. Macro should look for all the colums in all sheets and populate the value