I need a Macro that will loop through a file and copy a range of data from each sheet into a continuous range on a another sheet or workbook. The attached filed shows what I need. Really appreciate your help on this. Thank you.
A couple of points:
The row range will change each time I run; can't make an absolute reference. Example: 12/31/09 -> 3/31/10, or 2/28/10 -> 03/31/2010. I'm fine with requiring I define the value of the LBound and UBound ahead of time. The column range will not change. The starting cell off the range is always B13. The tab name will need to be pasted for every record/row copied and pasted.