Hi,

First time here and hoping you can help me.
I have little to no knowledge and have been trying my level best to google this before I ask the question. But I just can't seem to get my spreadsheet to work correctly.

What I have is a workbook with several sheets of data (Rows and Columns).
Each sheet is manually updated by importanting data from a website (Copy and Paste)
The number of Rows will always change but the number of Columns will not.
Each sheet has exactly the same number of Columns, however we can not simply just copy a entire row, as there may be notes.

For example Sheet2 may be 6 Rows 8 Columns this week, but next week Sheet2 may have 16 Rows.

Sheet 2|| Sheet 3|| Sheet 4
A B C|| A B C|| A B C
1 X X X|| 1 X X X|| 1 X X X
2 X X X|| 2 X X X|| 2 X X X
3 X X X|| 3 X X X
4 X X X||

Now for the tricky bit

I want to consolidate all this data on one sheet, but it needs to clear the existing data from that sheet.

Now I figure this is the easy part since I can input a static cell, with a value, on the sheets 2-4 and have a column insert that value into a column on the Sheet1(The consildation sheet)

So let me explain;

I want to push a button and it must search Sheet1 from Row 2 (Row 1 is headings) for data in a Column, that matches a Cell in Sheet2 and delete that row on Sheet1.

It must then copy Row 2 to "X" from Sheet2 (Column A to G only) to the end of the Rows in Sheet1.

Thank you in advance for all your help.