Copy multiple ranges from one wbook to another

I am trying to copy specific ranges from one workbook ( which comes by email everyday). data is dynamic everyday for each range
in the sample workbook I have for example I am trying to copy Range("A4:H6") only and not the total row below and Range("A10:H17")
and paste it into a different Workbook with the two ranges merged together.
book1s.xlsx

Are you intending to create a historical log based upon the emailed data. In other words will the emailed data be compiled into the other workbook as a collection of all of them, or will it be used for that day only and essentially re-used/sent each day.

Also will the data be always reflect the same Ranges or do the ranges change too?

Hi,
No historical data, it's new data comes everyday , which needs to replace the older data in the target wbk , so basically the emailed data is resent everyday and the same process needs to be done everyday .
the ranges tend to be dynamic as there could be more rows or data everyday in these ranges.
Hope this helps to explain

Ok, So from what I can tell, you essentially need to remove all the titles and be left with just the data.

The amount of lines changes with every new day and therefore the amount of data you require from that also changes everyday. You could have 4 rows and 8 rows one day and 2 and 15 the next for example.

yes thats correct .thanks..

This Really works , Thanks a lot