What I am trying to do is to copy D column , put into new workbook. E column into new workbook. But for now, I am trying to put different column into worksheets of same workbook before trying to figure out how to put in multiple workbooks.

However, when a number input into textbox is e.g. "2", it will only copy column E into a new workbook and stop there.

How do I loop through column D to a specific column (as stated by user input in textbox) and paste the column data into new workbook each time?