Just specify the final columns and rows required.
The source spreadsheets are not affected in any way. They are only read by the R script, then datatables identical to the source spreadsheets are created, then programmatically merged according to specifications. An output spreadsheet is then created.
John Akwei, ECMp ERMp Data Scientist