I have a requirement where I am given ten sheets of data and a specified number of rows from each sheet need to be moved into Sheet2. I've mentioned this order in Sheet1 (sample attached).
1. I need them to be cut-pasted because this process may repeat after one step of cut paste so I don't want duplication of data
2. The macro should run only once (cut-paste once) because I should be able to change the values in Sheet1 if required before I run the macro again.
2. Data needs to be pasted in the same order as specified in Sheet1
3. All data columns need to be copied from the sheets (columns may vary across sheets, hence all available columns need to be cut-pasted)
Any help would be very appreciated because I don't want to do this manually