Finding blank cells and pasting below each blank cell

Hi, I'm new to macros / excel pgm and would appreciate if someone could help me out with this issue:

I have data in different sheets that need to be copied and pasted into one sheet to provide an overview. The data from, say Sheet 2, first gets copied and pasted (Ctrl A + Ctrl C + Ctrl V) starting from the first cell of Sheet 1. After this, Column B in Sheet 1 is searched for the first blank cell, and then data from Sheet 3 (Ctrl A, C, V) is copied into the cell in Sheet 1- col. A after the 1st blank cell in Sheet 1- col B. Similarly, data from Sheet 4 is copied into the cell in Sheet 1-col. A after the 2nd blank cell in Sheet 1-B. this process is repeated until all the data from all 5 (or n) sheets are copied into Sheet1.

I hope i didn't confuse you guys too much with the question. Can someone please help me out with a macro for this? Thanks a ton!

Hi,

Thanks for your response. I've attached a sample excel sheet. So here's my situation:

Sheets 2,3,4 have random data in different table sizes. These need to be pasted one below the other in Sheet 1, i.e. all data in Sheet 2, followed by all data in sheet 3 then sheet 4.

So I do Ctrl A after selecting A1 in Sheet 2 and copy, paste the table in Sheet 1. I then notice cell A406 is blank, so I paste all data from Sheet 3 starting from A407 in sheet 1. the next blank cell is A752 => i then copy all data from sheet 4, paste it in A753.

I need to repeat this until all my sheets are copied (sheets 2,3,4 in this example. in my case i could have 10 sheets or even more).

Thanks!