I need to copy data from 1 excel speadsheet to another.

I have tried this using a Excel Macro but my problem is....
Can't get it to Flip sheets!
(ie. copy from sheet 1 to sheet 1 in master is
OK but how do I go to next tab and repeat??)

Daily spread sheet had 80 tabs each containing data for one of the machines.

(this is not constant as some machines are off line or faulty)

Col1, Col2,Col3, Col9 ... ie..4-8 are off.

The master sheet contains all Cols 1 to 100.

Data is read from each sheet on-mass ie. Col1 is copied to Col1 in master -
there are other columns in the master which calculates results.