Sheet Linking - Project sheets to single metrics sheet
I have about 80+ projects running simultaneously. In each project sheet, I have some basic project information & metrics (duration of each milestone calculated from actual start & finish dates) which needs to be tracked and analysed.
The information & metrics from all projects should be collected in the Metrics sheet.
In the metrics sheet, each row will represent 1 project data.
row#1 == project#1
row#2 == project#2 & so on...
Is there an easier way to do so? Can I use cell linking? Will it be manual work (linking for each project)?
Or do I have to generate report instead of metrics sheet?
I want to create a dashboard from the Metrics sheet which will give an over view of all projects together.