How do I copy a formula along 31 columns in a summary spreadsheet without it
altering the column references? Because the data is coming from identical
spreadsheets but on different days of the month i need only the sheet number
to change.

Also is there a quick way to copy and paste the first formulated spreadsheet
across to the 30 others in one hit? Ive tried a couple of ways already
suggested but didnt get very far.

Thanks lots
Carol