Multiple sheet formulas

[ragatha]

I have 12 monthly sheets (all identical) with daily data in columns. I want to pull the data by week into a summary sheet. I want to be able to make the formula so it can select data from a specified sheet and specified day (column) for each row of data I am trying to summarize.

Anyone PLEASE HELP!

 

[erik.van.geit]

Hi, ragatha
Welcome to the Board !!!!!

after reading 5 times your post, each time inspired me a different interpretation
some sample data would enhance a lot the communication: responses will be more to the point

kind regards,
Erik