How would I get infromation from different .xls files? I am working with
numerious .xls files which contain simialar colomns. Each sheet has a column
for 2005, 2006, 2007, 2008. Is there a wayto get inforamtion from the "Total"
row lining up with the year from each sheet? Each sheet is from different
..xls files. This is all being done through a macro.