VBA to Merge data, remove duplicates and sort

Hi, attached is a sample workbook. Could I please have some help with a macro to combine data from two worksheets and then getting rid of duplicate rows as well as sorting based on a field. I've got two data tabs - 'Actuals' and 'Budget with a number of columns but they share the same columns (E:H) as shown in the file. I need to pull data in those identical columns into a consolidated worksheet. Since there can be duplication of rows from the two tabs (exactly the same content across all the columns specified), I would need to remove the duplicated rows and then sort them based on data in column E.

I have also mentioned my requirement on the 'consol' tab.

I've tried recording a macro but it isnt dynamic enough when the number of rows shift from month to month and I'm having to adjust the variables every month. Any help would be most appreciated.

Hi, thanks for your prompt response....the code runs very well. However it doesnt seem to clear the consol data before running the code for merging? So if I hit the run button twice, it appends the data to the existing rows...so it keeps multiplying. I guess we need a clearcontent somewhere in there?

Otherwise, it seems to run like a dream. Thank you. Look forward to your response.

Hi, thanks for the above. The Company code in the first column is being copied over to the 'consol' tab as a number and not as a text, even if it is a text in the other two tabs? Is there anything within the code that needs to be corrected so it picks the formatting from the other tabs?

Hi, apologies for the late response. Thanks for your help....its been immense and managed to sort it out for me. On the last query (before I got a response from you), I changed the 'DataOption:=xlSortNormal' within the Sort code to read 'DataOption:=xlSortTextAsNumbers' and for some reason it worked (not sure why as it was reporting text as numbers previously and the terminology 'SortTextAsNumbers' seems to indicate the opposite)!! But as it works, I've left it at that. I might have to revisit the above if the macro starts failing again.

But thank you so much for your help....much appreciated.