I would like to use a do loop to read in a series of excel files, save them as .dta files, then append the .dta files. Additional files are being generated regularly. I would like to be able to run the do file without having to specify a maximum value each time. For example, I would like not to have to specify 52 in the code below, since soon I will have more than 52 files:

**read in files by round, save as .dta
forvalues i = 1(1)52 {
import excel "all_bids_round_`i'", firstrow clear
save allbids`i', replace
}

**append the rounds files
clear
use allbids1
forvalues i = 2(1)52 {
append using "allbids`i'", force
}

Thanks very much!