Dynamic Input Tool

[Divyanshu22]

Hi,

while using the dynamic input tool, i need to select data from specific sheets and in the workbook there are 30 plus sheets.

now while appending the data from the selected sheets - 

problem-

the tool is appending data from sheet no 1 correctly but after that its picking up sheet no 10 and then 11.... and then sheet no 2 is picked up after sheet no 19 is done.

how do i append the data sheet after sheet.

the sheet no's are named as

[alexnajm]

I can't load the picture for some reason, but have you sorted beforehand? You can toggle the "Use Dictionary Order" to see if that helps.

Otherwise I would parse out the number and sort on that column before feeding them into the Dynamic Input! Here is a sample workflow attached.

[binuacs]

@Divyanshu22 Another option use the batch macro