Macro coding for writing new sheets

Hi,

I'd like to develop a new sheet in the same workbook based on data in the initial sheet. I'm including an example of that I'd like to happen. The sheet 'Stands' contains data related to specific areas and the costs and revenues of activities within those areas. The "new" sheet would calculate revenues ("R#'s) and costs ('C#'s) for management activities for the next 30 years that begin in years 1 through 15. I'd like to do this to simplify the task of creating this sheet which will need to be repeated for different sets of areas (Stands). I've tried creating a macro to do this but with poor results so far. Any suggestions? Thanks.