Pulling data from sheet1 to a list in sheet 2 based upon a date range

Hello,
I am in need of some assistance with a rather large spreadsheet, currently we track information for a product based upon the lot assigned, and the date the lot was transported. Based upon the week that the lot was transported that lot is moved from sheet 1 to sheet 2 and populated into a the correct column (i.e. if the lot was transported on 1/3/10, and the week range was 1/1/10 to 1/7/10, that lot would fall into that column on sheet2).

I created a mock up of our actual scenario, very much simplified, as I was hoping someone could show me how to go about this in a graceful fashion. I have looked at conditional formatting, but because the actual spreadsheet is for the entire year of 2010, I have 52 week ranges, and conditional formatting is of no help. I looked at doing macros, and I can make one for each week, although that seemed rather laborious and inelegant. Does anyone know of a better way to do this?

Thank you for reading my post, any help would be greatly appreciated,
Joel

Wow, thank you very much, and I hate to do this, but I looked over the v basic stuff you did, and I don't really understand it at all. I'm really sorry. Here's a sanitized version of the actual spreadsheet, I changed everything but the dates that we use. So in tab 1 we have the name of the object, the first date, and then either an accepted or rejected date, and duratiom from the first date to the second. The second tab is where we track how many were accepted and rejected within a given week, and then there's an average days calculation. If you could possibly show me how to get what you did in my sample spreadsheet to transfer into this second tab, so that I can populate those weekly columns I would be super appreciative. If not, I understand. Sorry about this, I thought I might be able to figure it out from the work you did, but I couldn't. Sorry.