I have a folder that contains several workbooks - each with an individual number
inside each workbook is a tab called STOCK
i want to be able to harvest all info in the stock tabs of each workbook - could I "consolodate"? or maybe a macro?
i will be wanting to do this action on a weekly...