I have a Master sheet in my workbook and I have 7 other sheets named 'One', 'Two' etc etc up to 'Seven'.

I need a macro that begins in 'One' and copies A2:Ox (where X is the last used row of data) and pastes VALUES below the last used row of data in the Master sheet. It then does this for sheet Two, Three etc.

Any help would be much appreciated.