What I am looking to do is get a function button (or similar) on sheet 1 that
can recognise the data put in a column and upon a click of a button transfer
data held in a certain cell elsewhere and the date onto sheet 2.

If this is not possible, what the whole purpose I am trying to do is on
sheet one have a=50 fields per day, where 3 figures are entered per line, 50
lines (ie 150 pieces of data per day) which calculates the average of the 3
numbers per row, and then the average of all these numbers appears in a
seperate field on the spreadsheet (this I have already achieved.)

Then this data can be transferred as just the average of all the figures
onhto sheet 2.

I am not too particularly concerned in losing the figures each day, as long
as the average is transferred. Obviously I would prefer the data to remain
for records, and then spreadsheet can pick up from the new date, but this
would need a new formula on page one of the spreadsheet as the way I have it
set up at the moment, the data would just carry on and not give me a true
average per day.