Need help on Macros

[VineetJ]

Hi All,

Currently I am creating a dashboad, which would contain multiple sheets (each per project) for projects within the account. I want to copy the selective project information across all the projects on the main dashboard sheet which is a consolidation for all the projects.

You can refer my sheet uploaded on Box.net
http://www.box.net/shared/caxmj3lakg1i68tzgsso

Please suggest me how to complete this task?
Please note that the project count would keep on changing thus the sheets in the workbook are going to vary accordingly.
I am using excel 2007 currently.
Please take into consideration all this and suggest me a solution.

Thank you,
Vineet

 

[bensonsearch]

Hi,
im not sure what the question is. do you want the number of sheet feilds to equal the sheets for that project?