Excel 2007 : Grabbing Data from Table A to B

Hi there, I have a very annoying problem that I can't think and solve.


Basically, I have two tables called Table A and Table B. Table A will feed data to Table B when I activate a macro.


Table A is a week data while Table B is a month data. Every week, the dates in Table A will change to reflect the current week.


The problem is when Table A feed into Table B, the macro will not intelligently know where to place Table A data to Table B. Note that if Table A data is for 5-Oct, then it will place the data to Table B in 5-Oct too.


Please help!