VBA - Finding the start of second data set in same Column

The attached sample data file is below. I am writing a macro to copy each of the four data sets separately to a different sheet in a certain spot. Long story short - What i cant figure out is the best way or any way to be able to copy the data set below the first data set.

What I've tried/Additional Info:

I was using .Finds to look for a text string and returning whats above up to the starting location. For Example i know I always need to copy from B4 to Column E & the row number that right above the one that contains the text 'Total Sales' in Column A. For the Table below Last Quarter - Total Returns, I cant always find the correct row to start the copy. I cant use a static reference since sometimes total sales is Merged into two rows, sometimes not (Total Sales is taking two rows in Column H as in the sample data as an example). So LastRow1 - 2 would work if sales occupies on row but not work if its merged into two rows. Is there an easier way to find the start of the Returns Row for both the last quarter data set as well as the start of the data set for this quarter returns?


This is my most recent attempt:

Please Login or Register  to view this content.

This however isnt working properly so why i am trying to find another way

Please Login or Register  to view this content.

I am also aware my style is fairly rudimentary as i am self taught from the internet and mainly what other people post on forums. Any constructive feedback is helpful.

Yeah, I wish the input file was cleaner. Attached is the output file. Basically it is just creating a formatted version with specific headers that can be exported to ppt, as a picture, etc. I am just trying to automate the move process from input to the output. Sometimes it wont have prior quarter data or it wont have return data so the input can be all over the place. I learned some If Statement logic for VBA so i have that, just have to figure out how to move the data..

Exactly, it is just pasting the customer rows to the output tab on the left.