Unhide a row on 4 sheets when a value is entered in the row above it in master doc?

[tonywatsonhelp]

Hi Everyone,
So I have 4 sheets all the same 1 is Data1 data2 etc.

(If we could write this macro to run on all sheets called "Data**" that would be great.)

NOw data1 is where the data is entered,

So what I need is a macro that if any cell in column C of Data1 is changed it unhide the next row on all 4 sheets so if its row 7 it unhides row 7 on then all

any ideas how to do this.

Thanks

Tony