I having 3 worksheet in 1 file that need to be read in 1 qvw eg:vegetable, tropical asian and fruit international. All worksheet format shown the same layout.
Please read Rob Wunderlich example on how to read from excel worksheets. You can loop thru the excel file. Also, look at this thread and this should help you.