Dynamic Sum from One sheet to another

[Topcat04]

Hi All

Im trying to get the following formula to work across sheets without any luck.

=SUM(BB5INDIRECT(ADDRESS(ROW(),COLUMN(OFFSET($B$4,2,MATCH(Summary!$B$2,$B$4:$DA$4,1)))))))

This works fine when its located on the same sheet as the data (sheetname is UnitSales)

I want to use it on a Summary Sheet and tried changing the Formula to the below - but it returns an error.

=SUM(UnitSales!BB5INDIRECT(ADDRESS(ROW(),COLUMN(OFFSET(UnitSales!$B$4,2,MATCH(Summary!$B$2,UnitSales!$B$4:UnitSales!$DA$4,1)))))))

Your help to be able to get this to work on a Summary Sheet is appreciated,

 

[Topcat04]

Hi Zelgar
No the master sheet does not have daily data. It is an accumulation of a lot of data - some needed such as Weekly sales, but some not needed so much at the moment such splitting out stock between DC's and UPC codes etc
I have added a snippet of the Master Sheet to give an idea - as you can see there is currently 2000+ lines and this will grow each week.
Thanks for your feedback.

 

[SkipVought]

Here's what the been hoping for ...

So using that example, what would the summary look like?

 

[SkipVought]

I'm still waiting for what you expect to see on the Summary sheet based on the sample data you posted.

It's a pretty simple request and we've been waiting 2 days!

 

[Topcat04]

Skip
Sorry been away from keyboard for the evening as out.
The 12weekSales is the summary sheet as far as the data is concerned.
It has more development but until I can get the sales summing from one sheet to another, it's still developing.
Sorry for the confusion.

 

[SkipVought]

That is not what I asked for!