Hello please could anyone tell me how can i get data from all tabs in a workbook using Connections.. as i did try and test but it only brings in data from 1st sheet.. and i am not sure how can i select all sheets.. (excel 2007)

Thanks