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!