Merge first column From Multiple Sheets Into One Sheet

see attachment, run macro "test"

its workin on the raw data that I supplied, thanx, but it not working on the actual data, getting the error message "Run time error 1004" No cells were found.