I need to copy a sheet from 3 separate workbook into a single new one.
Can this be achieved by using roo?
Short answer: No.
I did not want to reimplement a spreadsheet program with roo. Roo is mainly for reading as many spreadsheet types as possible - not writing to spreadsheets.
I think you can do this with the 'spreadsheet' gem.