We have a excel .xls data file having numerous sheets each containing maximum number of rows (65000). We want to generate a separate text or csv file to include data present in all the sheets together. The data in each sheet is of identical format. Could anyone help with a suitable macro code which can generate such file.