hi..
i have status report for each project. Each sheet is dedicated for one project and contains history of project. We append a new row every week for the latest update for each project in their respective sheets.
i need to get a consolidated report of all projects in a single excel sheet...