I have a 280 * 280 grid of data in a worksheet in r1c1 reference style.

I need to take the co-ordinants and content of each cell and put them into a second worksheet i.e the second worksheet would have 3 columns - Column#,Row#,Cell-Data.

Any ideas? I have over 50 spreadsheets to do!!