Simple Tweak in VBA required while copying data from one sheet to another

[Jyotirmaya]

I want to copy my data of "Sheet 1" and "sheet 2" to "sheet 3"

I have the following code

Sub sbCopyRangeToAnotherSheet()
Sheets("Sheet1").Range("A1:P100").Copy
Sheets("Sheet3").Activate
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub

1. Now I want the copied data of sheet1 in sheet3 should be of BLUE color
2. After copying Shee1's data in sheet3, Sheet2's data will copy below to the Sheet1's data & of which Green color.
3. After copying both data Column C will be sorted from smallest to largest.

 

[Jyotirmaya]

To move incorrect rows to the bottom lines instead of filtering just sort column B.

Thanks ZVI it works

I don't know much more about VBA code, I am just collecting codes for my work to be done easily with some clicks.
Thank you.

 

[ZVI]

You are welcome! See you here