Hi - my accounting system spits out account statements for every property on its own tab, with a workbook of properties that can be many tabs in length. Every property's name is in cell A5 for every tab of the worksheet. I need a macro to convert the the data to columnar format where there would 3 columns with property name, account description, and date. Then for all the data from every tab would be combined into these 3 column names in a single tab - where I could make a pivot table to better analyze all the data.
Any help would be very much appreciated!