Looks like a good page on it here: http://www.cpearson.com/Excel/foldertree.aspx
lists the... worksheets and the bottom used cell for each sheet
In order to do this you would need extra code to open, extract data and close each, which could be a long process.
@Olly398 started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Looks like a good page on it here: http://www.cpearson.com/Excel/foldertree.aspx
In order to do this you would need extra code to open, extract data and close each, which could be a long process.