Identify, copy and paste certain rows with certain conditions to another worksheets

[nanas]

Hello there

Based on the title above, I need your help to identify the first 3 digits in the cells belong to which worksheets with some condition:

if the first 3 digits are 001-004, the whole value will be copied and paste into newsheet named Account1. if the first 3 digits are 005-009, the values will be copied and paste into Account2. And others will be copied and paste into Account3.

Below is the example: (*Sheet1, Account1, Account2, Account3 are the name of sheets)

Sheet1 | Account1 | Account2 | Account3

code | code | code | code
------ | ------- | ------ | --------
00123 | 00123 | 00656 | 01189
00656
01189