You can export a range of data from one Excel file to another within your OneDrive folder or even between different OneDrive accounts. To do this, you need to select a source file, worksheet, and specify a range of cells using the optional parameter Range. If you select multiple sheets to merge into a master view, you can specify the range of cells as well. In this case, the data from the specified range of these sheets will be merged and loaded to the destination worksheet.